All, Our requirement is to arrive at a result set based on the Where qualification which is externally built.
We used the Active Link -> Set Field Action Using SQL Query as below: Select col1, col2 from table1 where $Where Qualification$ The Where Qualification is externally built at Run time. For E.g., col3 = '45' or col3 = '56' When Remedy parses this SQL, it adds one more Single Quotes for the values as shown here: - col3 = ' '45' ' or col3 = ' '56' ' So the Query becomes, Select col1, col2 from table1 where col3 = ' '45' ' or col3 = ' '56' ' Oracle throws error *** ERROR *** ORA-00933: SQL command not properly ended Is there any way to drive this Where Qualification externally with proper syntaxing? Your help much appreciated. Thanks & Regards, Vijayalakshmi Paulraj --------------------------------------------------------------------------------------------- This message, including any attachments, contains confidential information intended for a specific individual and purpose, and is intended for the addressee only. Any unauthorized disclosure, use, dissemination, copying, or distribution of this message or any of its attachments or the information contained in this e-mail, or the taking of any action based on it, is strictly prohibited. If you are not the intended recipient, please notify the sender immediately by return e-mail and delete this message. --------------------------------------------------------------------------------------------- _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org Platinum Sponsor: RMI Solutions ARSlist: "Where the Answers Are"
