Hi Martin,
Thank you for your input, but the problem I'm having is with how the SECOND "ORDER" noun is behaving. When the command is passed to SQL, SQL takes the string literally, and sees the "?CMS.ORDER" as "?CMS. ORDER", which returns a syntax-error. I haven't tried assiging CMS.ORDER to another variable, but even if it works, this is not a workable solution since TABLEUPDATE would need to have the ability to reassign this variable for each update. Any other ideas?
John MR Fitzgerald
Order Inc.