Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Free tables vs DBC
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00740632
Message ID:
00740646
Views:
26
Hi Alejandro,

Also, you would not be able to use transactions. Transactions are very useful when performing table updates. For example, in my app I use transactions when run the pay definition table to create payroll transactions for each employee. If the payroll transactions complete successfully (e.g. all tableupdates() returned true) then I do a end transaction. If any insert does not update successfully (e.g. the tableupdate return false), then I print out the employee, error message, and the exact type of update that failed (e.g. regular salary, overtime, FTW, SS, etc). Then I issue a rollback. This avoid the situation where the app fails with no way to know which transactions were written and which transactions failed. Either all tranactions are committed, or no transactions are committed.

LelandJ
Leland F. Jackson, CPA
Software - Master (TM)
smvfp@mail.smvfp.com
Software Master TM
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform