Hi all,
Got a really weird problem. I have an insert I have to do on a table in SQL Server. I have this set for manual transactions and do an SQLCOMMIT after the insert which uses SQLEXEC. In my application, this insert is returning -1, as in it doesn't fly. This very same command can be successfully run manually from the Command Window and it MSQUERY and any of the SQL Server management tools. (It's SQL Server 6.5).
No errors or anything useful to go on. It works everywhere but in the code process. Any ideas?
------------------------------------------------
John Koziol, ex-MVP, ex-MS, ex-FoxTeam. Just call me "X"
"When the going gets weird, the weird turn pro" - Hunter Thompson (Gonzo) RIP 2/19/05