Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations Mike Lewis on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How to rollback VFP client using SQL backend
- Thread starter vfpshe
- Start date
Mike Lewis
Programmer
Vfpshe,
The best way is to write a stored procedure to handle your update. Within the stored procedure, use BEGIN TRANSACTION, ROLLBACK TRANSACTION and COMMIT TRANSACTION commands.
The SP does not have to be elaborate - just a simple wrapper to include those commands.
Mike
Mike Lewis
Edinburgh, Scotland
The best way is to write a stored procedure to handle your update. Within the stored procedure, use BEGIN TRANSACTION, ROLLBACK TRANSACTION and COMMIT TRANSACTION commands.
The SP does not have to be elaborate - just a simple wrapper to include those commands.
Mike
Mike Lewis
Edinburgh, Scotland
- Thread starter
- #4
Mike Lewis
Programmer
VFPshe,
Will pressing ESC while the transaction is being processed in SQL rollback any updates done?
No. In fact, I didn't read your question carefully enough. Sorry.
The rollback feature I described is only good if an error or interruption occurs on the server. You can't use it to initiate a cancellation from the client.
I suggest you follow up Flutepir's suggestion instead.
Mike
Mike Lewis
Edinburgh, Scotland
Will pressing ESC while the transaction is being processed in SQL rollback any updates done?
No. In fact, I didn't read your question carefully enough. Sorry.
The rollback feature I described is only good if an error or interruption occurs on the server. You can't use it to initiate a cancellation from the client.
I suggest you follow up Flutepir's suggestion instead.
Mike
Mike Lewis
Edinburgh, Scotland
- Status
Similar threads
