Canceling form with related table changed
Canceling form with related table changed
(OP)
Hi
Lets say we have invoice form (table_1) and we changed and saved something in related table_2. Now we want to cancel invoice form and roll back all the changes in related table_2.
What is your idea for handling this cancel? We use temporary tables for related records and update table_2 only when request is completed. Other ideas ?
Lets say we have invoice form (table_1) and we changed and saved something in related table_2. Now we want to cancel invoice form and roll back all the changes in related table_2.
What is your idea for handling this cancel? We use temporary tables for related records and update table_2 only when request is completed. Other ideas ?
RE: Canceling form with related table changed
If the update is done inside a transaction frame, you can roll back the updates. Check out LOGOUT, COMMIT & ROLLBACK in the help.
Regards
RE: Canceling form with related table changed
User's edit form can lock related table for long time. We have other automated processes writing into that tables that won't stop and wait for COMMIT OR ROLLBACK ( scanners reading barcodes)
We tried different isolation levels but SQL manual clarified all.