Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
SQL Transactions
Message
From
14/04/2000 19:14:27
Larry Long
ProgRes (Programming Resources)
Georgia, United States
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Title:
SQL Transactions
Miscellaneous
Thread ID:
00359923
Message ID:
00359923
Views:
57
Is this a correct way to handle SQL transactions?

2 sql views

BEGIN TRANS
.
.
code for mods to both views, i.e. adding records, updating fields
.
.
lupdateok=tableupdate(1,.t.,'view_a')
lupdateok=lupdateok and tableupdate(1,.t.,'view_b')

IF NOT lupdateok
ROLLBACK
ELSE
END TRANS
ENDIF
L.A.Long
ProgRes
lalong1@charter.net
Next
Reply
Map
View

Click here to load this message in the networking platform