If I understand nested transaction correctly, it's like creating an invoice 
master in a transaction (remain opened), then add invoice line item in nested 
transaction (start and end nested transaction in one go), add nth line of 
invoice items in new
nested transaction continously. Failure of one nested transaction won't affect 
other nested transaction. User simply correct the failed one and move on. At 
the end, if user cancel the invoice master (not line item) opened transaction, 
all completed
nested transactions would also be rolled back. It means as long as the invoice 
master transaction was not ended (validate or cancel), all other related 
records like inventory of those items or item master (if summary info was kept 
there) would be
locked. Other users might not be able to access them during the period.

If there's no UI, why you need nested transaction? It's all on assumption of my 
understanding on nested transaction and could be wrong.

Alan Chan

4D iNug Technical <4d_tech@lists.4d.com> writes:
>They execute in milliseconds as I never put user interfaces - or even alerts - 
>inside transactions. Just a lot of error handling and then report the error 
>after the final CANCEL TRANSACTION.

**********************************************************************
4D Internet Users Group (4D iNUG)
FAQ:  http://lists.4d.com/faqnug.html
Archive:  http://lists.4d.com/archives.html
Options: http://lists.4d.com/mailman/options/4d_tech
Unsub:  mailto:4d_tech-unsubscr...@lists.4d.com
**********************************************************************

Reply via email to