Local Variables are out of scope to the sqlexec function - especially in my case since the that command is in a different method than the method that builds the string.

>OK... isn't that was encapsulation and data hiding is for. Also, declaring variables LOCAL so they are unique within a method even if they are the same name in another method?
>
>>There are thousands of tables and lots of fields. To much of a chance to stomp on existing variables.
>>
>>
>>>>If I change all the oRec.field values to variables, it seems to work fine, but that adds other issues.
>>>
>>>Other issues, such as?
>>>
>>>BOb