After fiddling a bit, it appears the SPT commands are not operating correctly when run within the caBuilder. It is not a problem with the builder code. Running in STEP ON mode I can see that the SQLTABLES and SQLEXEC commands are returning "0". So I cut an paste these lines exactly as written in the prg to my command window and execute them where they return "1" as they should. Then I can continue with the program execution in the debugger window.
I have not encountered this behavior before where the SPT commands don't work in the prg but work fine in the command window. Any ideas on what is causing this?
Paul
I can't complain but sometimes I still do - Joe Walsh