Believe it or not, that was it. Unbalanced with that parenthesis. I looked at that damn command for hours and didn't see it. Sometimes extra sets of eyes and brains helps a lot.

Thanks, man, I owe you one!


>Is this a retype or cut/paste. The INSERT is not formed correctly.
>
>

>>nGoodInsert=SQLEXEC(nCH3,"INSERT INTO action clientid,program_id,actnsk) VALUES
>>(&cClientid,'&cProgram_ID','&cActnSK'")
>

>
>Should be
>
>

>>nGoodInsert=SQLEXEC(nCH3,"INSERT INTO (action clientid,program_id,actnsk) VALUES
>>(&cClientid,'&cProgram_ID','&cActnSK')")
>

>
>And you might try using parameters instead of the macro expansion:
>
>

>>nGoodInsert=SQLEXEC(nCH3, "INSERT INTO (action clientid,program_id,actnsk) VALUES (?cClientid, ?cProgram_ID, ?cActnSK)")
>

>
>-Mike