Information générale
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
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.
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement