- It creates a _ROLLBACK_basetable table to hold the contents of the basetable to capture all of the data in the basetable before modification.
- Deletes the records from the basetable for the feed.
- Inserts new records into the basetable for the feed.
- If step 3 is successful, it deletes the ROLLBACK_basetable table.
- If step 3 is unsuccessful, it tells you "This grid cannot be saved. Roll back in process. See table..." this means, hey, dude, something’s whack, and I can’t save – check the ROLLBACK table. If you subsequently try to save, (without addressing the ROLLBACK table), it will fail, because it can’t create the rollback table in step 1 – it already exists. You are stuck until you address the rollback table(most of the time, by dropping the table).
See attached for example error.
No comments:
Post a Comment