How To Wrap Remote Views into One SQL Transaction (186138)
The information in this article applies to:
- Microsoft Visual FoxPro for Windows 3.0
- Microsoft Visual FoxPro for Windows 3.0b
- Microsoft Visual FoxPro for Windows 5.0
- Microsoft Visual FoxPro for Windows 5.0a
This article was previously published under Q186138 SUMMARY
You can wrap multiple remote views into one transaction, which allows you
to commit or rollback all changes to the back-end data tables in one step.
For example, a bank transfer between a savings account and a checking
account. If the subtraction from the savings account fails because of
insufficient funds, you do not want the addition to the checking account to
be completed. Thus, you can rollback the entire bank transaction.
REFERENCES
For more information on creating connections:
Visual FoxPro Developer's Guide, Chapter 8, "Defining a Connection";
"Creating Views"
For more information about making an updateable view:
Visual FoxPro Online Help; search on "View Designer"; topic: "Update
Tab"
(c) Microsoft Corporation 1998, All Rights Reserved. Contributions by David
Botzenhart, Microsoft Corporation
Modification Type: | Minor | Last Reviewed: | 7/15/2004 |
---|
Keywords: | kbhowto KB186138 |
---|
|