Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Passthrough
Message
From
18/08/2000 12:03:51
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL Passthrough
Miscellaneous
Thread ID:
00406714
Message ID:
00406714
Views:
63
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
Map
View

Click here to load this message in the networking platform