I do not know. I would start a new thread and post what you are having problems with the specific SPT code in a prg versus the command window observations. There are plenty of SQL Server gurus here that could probably answer that. My DB expertise is with Oracle instead of SQL Server.
>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
Mark McCasland
Midlothian, TX USA