How to Set Search Expr to Query String with Quote(') in escript?
(Doc ID 543203.1)
Last updated on MARCH 17, 2020
Applies to:Siebel Tools - Version 22.214.171.124 SIA  and later
z*OBSOLETE: Microsoft Windows 2000
User needs to query contact BC using eScript with search criteria as:
Last Name: O'LastName
First Name: FirstName
Work Phone #: 9999999999
The character quote (') in last name is causing the problem in query.
The search expression is set as :
[User has already defined val1=FirstName,val2=O'LastName,val3=9999999999]
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