How to Set Search Expr to Query String with Quote(') in escript?
Last updated on SEPTEMBER 21, 2017
Applies to:Siebel Tools - Version 126.96.36.199 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?
Sign In with your My Oracle Support account
Don't have a My Oracle Support account? Click to get started
My Oracle Support provides customers with access to over a
Million Knowledge Articles and hundreds of Community platforms