General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Another SQL PH question. I open up a form, the init runs the code that makes a connection, does SQLExec, sets to properties for updates. Then the control sources of the text boxes on the form are set to SQL cursor. I make the changes then fire a USE command that sends the changes, last connection is closed. My situation is I open up the form and change info in the text boxes. Then I decide that I don't want to do the changes after all. If I just close the connection without the USE command the next time I try to connect I get an error that connection handle is invalid. I have tried SQLCancel() and SQLRollback but nothing works. Thanks for the help.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only