...
All DBC SQL operations are performed within a database transaction. the following SQL errors cause the transcaction transaction to be roled rolled back:
- An update statement updates ) rows and autocreate is false
- A auery query with autocreate=true is missing a create statement
- A query when autodelete is true and is missiong missing the delete statement
- A query with the Delete statement and the delete Key is not defined
- A delete statement where the specified delete key cannot be found in the retreived resultset
- Browsing the URL to generate the schema for querysets
- Updates do not trigger errors due to several valid use cases for update failures ex: autocreate=true
- When calling a queryset with 1 or more autocreate or autodelete=true, iternally the DBC is likely to execute multiple SQL statements - it will try to delete all rows that were deleted from the form resultset that were originally in the resultset reteived from the database. It will try to update rows from the form resultset - and if autocreate is true and the update fails, it will execute an insert for each update failures. If any one of those fails (except Update) the transaction will be rolled back
...