Never mind. A coworker suggested trying to build the enter SQL query in a separate character field and then substitute that into the SQL set fields rather than building it piecemeal there. That worked, it did not escape the single quotes using this action.
Thanks, Roy //SIGNED// ROY ASHCRAFT, Contractor, 2 SOS/SYOE Remedy ARS Support, SAIC (402) 294-8225, DSN 271-8225 [email protected] -----Original Message----- From: Action Request System discussion list(ARSList) [mailto:[email protected]] On Behalf Of Ashcraft, Roy W CTR USAF AFWA 2 SYOS/SYOE Sent: Wednesday, September 22, 2010 8:59 AM To: [email protected] Subject: Set Fields from SQL ---------------------- Information from the mail header ----------------------- Sender: "Action Request System discussion list(ARSList)" _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org attend wwrug10 www.wwrug.com ARSlist: "Where the Answers Are"
