I am having a devil of a time with executing a stored procedure on Sybase. I am using sqlexec() to run the procedure with it's parameters. The result returned is 1, but the change is not made.

I have changed the sqlsetprop of the handle to change the transactions prop to 2 and used sqlcommit(). Again, the result is 1, but no change.

I can take the exact same sqlexec snippet (copy/paste) into Rapid SQL and it runs like a top and makes the change. Can't figure out what I do not have set correctly. Can anyone point this old boy in the right direction?