Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Transactions and GetAutoincValue()
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Transactions and GetAutoincValue()
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows 2003 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01373138
Message ID:
01373138
Views:
59
Does GetAutoincValue() work ok with Transactions? My program does the following:
BEGIN TRANSACTION
Create an invoice header record
InvoiceKey = GetAutoincValue()
Create a set of invoice line records that include the Invoice Key from above.
If all ok
  END TRANSACTION
else
  ROLLBACK
endif
Is there any problem here if a rollback is done? How does this affect any other users in the system running the same code at the same time?
Beer is proof that God loves man, and wants him to be happy. - Benjamin Franklin
John J. Henn
Next
Reply
Map
View

Click here to load this message in the networking platform