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
...
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. |
...
Code Block |
---|
for(var i = 1; i <= foundset.getSize(); i++){ foundset.setSelectedIndex(i); // operate on the selected record } |
Note |
---|
See also the JSFoundset's setSelectedIndex method. |
Accessing a Record Object
...
Code Block |
---|
for(var i = 1; i <= foundset.getSize(); i++){ var rec = foundset.getRecord(i); // does not affect the selected index } |
Note |
---|
See also the JSFoundset's getRecord method |
Accessing Data Provider Values as an Array
...
Code Block |
---|
var ids = databaseManager.getFoundSetDataProviderAsArray(foundset,'order_id'); for(i in ids){ var id = ids[i]; } |
Note |
---|
See also the JSFoundset's getFoundSetDataProviderAsArray method |
Related Foundsets
Foundsets are often constrained or filtered by a Relation. In this situation, the foundset is said to be a Related Foundset and its default SQL query will include in its Where Clause, the parameters by which to constrain the foundset.
...
A Foundset may be automatically updated when the client receives a Data Broadcast Event . If the data change affected the table to which the foundset is bound, the foundset will be refreshed to reflect the change.
...
Find mode can be programmatically cancelled by invoking the loadAllRecords method of the foundset. The foundset will revert to the query prior to entering find mode.
...