Hi All, We have migrated our custom (non-ITSM) ARS application from 7.1 (Solaris-Sybase) to 8.1 (Linux-Oracle). Currently facing issues with Set Field SQL action in various workflows due to difference in SQL statments in Sybase and Oracle. For instance in one of the activelinks, on sybase select Install_History from CM_Change_Mgmt where Change_Request__ = "$Change_RequetID$" which gets error on Oracle, to rectify it I made the below change select Install_History from AOL_CM_Change_Mgmt where Change_Request__ = '$Change_RequetID$' single-quote Since I don't know for the presence of "double-quotes" in the workflows for similar actions, what would be the best way to rectify the set-fields actions,push field, direct sql?? Regards, Saurabh
-- View this message in context: http://ars-action-request-system.1093659.n2.nabble.com/Set-field-SQL-statement-correction-tp7601582.html Sent from the ARS (Action Request System) mailing list archive at Nabble.com. _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org "Where the Answers Are, and have been for 20 years"
