Page History
...
Note |
---|
See also the Database Manager's saveData and getFailedRecords methods, as well as the exception property of the JSRecord |
Rolling Back Data Changes
A developer can programmatically issue a command to rollback the contents of the entire In-Memory transaction, causing newly created records to be removed and modified records to be reverted to their state prior to the start of the In-Memory transaction. The developer can optionally choose to rollback changes for a specific record, leaving the rest of the transaction unaffected.
Note |
---|
See also the Database Manager's rollbackEditedRecords method, as well as the rollbackChanges method of the JSRecord. |
...
What about Deleting Records?
It is important to note that record deletes are not part of the In-Memory transaction. When a record is deleted, the instructions are sent to the database immediately and the delete cannot be rolled back.
Note |
---|
See also the deleteRecord method of the JSFoundset. |
...
The Servoy Foundset
The Servoy Foundset is a developer's window into Servoy's Data Binding layer. A single foundset always maps to a single database table (or view) and is responsible for reading from and writing to that table. From the user interface, a foundset controls which records are loaded and displayed, as well as how records are created, edited and deleted. From the developer's perspective, a foundset is a programmable object with specific behaviors and run-time properties that provide a high-level abstraction to facilitate low-level data operations.
...
Code Block | ||||||
---|---|---|---|---|---|---|
| ||||||
SELECT * FROM customers WHERE customerid IN (?,?,?,?,?,?,?,?) ORDER BY customerid ASC |
A foundset's underlying query can change dramatically throughout the client session. The following events will modify a foundset's underlying query
...