How to Set Search Expr to Query String with Quote(') in escript?
(Doc ID 543203.1)
Last updated on SEPTEMBER 21, 2017
Applies to:Siebel Tools - Version 188.8.131.52 SIA  and later
z*OBSOLETE: Microsoft Windows 2000
User needs to query contact BC using eScript with search criteria as:
Last Name: O'Neal
First Name: Robert
Work Phone #: 3154323300
The character quote (') in last name is causing the problem in query.
The search expression is set as :
[User has already defined val1=Robert,val2=O'Neal,val3=3154323300]
The string 'strsrchExpr is formed as below:
Though this does not give any syntax error, this does not return the record in query.
Then the following was we tried:
This again doesn't give syntax error but string formed as below does not return the record either.
How can the search expr be set to to query string with quote(') in it, in eScript?
To view full details, sign in with your My Oracle Support account.
Don't have a My Oracle Support account? Click to get started!
In this Document