John,

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