{column:padding=0px|width=80px}{column}{column}{column}
Method Summary
performUpdate()
Do the actual update in the database, returns true if successful.
void
resetIterator()
Start over with this iterator 'next' function (at the foundset selected record).
{column:padding=0px|width=100%}{column}
Method Details
Go to next record in this updater, returns true if successful.
Since
Replace with version info
Parameters
Returns
[Boolean] – true if proceeded to next record, false otherwise
Also see
External links
Sample
controller.setSelectedIndex(1) var count = 0 var fsUpdater = databaseManager.getFoundSetUpdater(foundset) while(fsUpdater.next()) { fsUpdater.setColumn('my_flag',count++) }
performUpdate
()
Do the actual update in the database, returns true if successful.
There are 3 types of possible use with the foundset updater
1) update entire foundset, not possible when the table of the foundset has tracking enabled, will fall back to 3.
2) update part of foundset, for example the first 4 row (starts with selected row)
3) safely loop through foundset (starts with selected row)
Since
Replace with version info
Parameters
Returns
[Boolean] – true if succeeded, false if failed.
Also see
External links
Sample
//1) update entire foundset var fsUpdater = databaseManager.getFoundSetUpdater(foundset) fsUpdater.setColumn('customer_type',1) fsUpdater.setColumn('my_flag',0) fsUpdater.performUpdate() //2) update part of foundset, for example the first 4 row (starts with selected row) var fsUpdater = databaseManager.getFoundSetUpdater(foundset) fsUpdater.setColumn('customer_type',new Array(1,2,3,4)) fsUpdater.setColumn('my_flag',new Array(1,0,1,0)) fsUpdater.performUpdate() //3) safely loop through foundset (starts with selected row) controller.setSelectedIndex(1) var count = 0 var fsUpdater = databaseManager.getFoundSetUpdater(foundset) while(fsUpdater.next()) { fsUpdater.setColumn('my_flag',count++) }
void
resetIterator
()
Start over with this iterator 'next' function (at the foundset selected record).
Since
Replace with version info
Parameters
Returns
void
Also see
External links
Sample
controller.setSelectedIndex(1) var count = 0 var fsUpdater = databaseManager.getFoundSetUpdater(foundset) while(fsUpdater.next()) { fsUpdater.setColumn('my_flag',++count) } fsUpdater.resetIterator() while(fsUpdater.next()) { fsUpdater.setColumn('max_flag',count) }
setColumn
(name, value)
Set the column value to update, returns true if successful.
Since
Replace with version info
Returns
[Boolean] – true if succeeded, false if failed.
Also see
External links
Sample
//1) update entire foundset var fsUpdater = databaseManager.getFoundSetUpdater(foundset) fsUpdater.setColumn('customer_type',1) fsUpdater.setColumn('my_flag',0) fsUpdater.performUpdate() //2) update part of foundset, for example the first 4 row (starts with selected row) var fsUpdater = databaseManager.getFoundSetUpdater(foundset) fsUpdater.setColumn('customer_type',new Array(1,2,3,4)) fsUpdater.setColumn('my_flag',new Array(1,0,1,0)) fsUpdater.performUpdate() //3) safely loop through foundset (starts with selected row) controller.setSelectedIndex(1) var count = 0 var fsUpdater = databaseManager.getFoundSetUpdater(foundset) while(fsUpdater.next()) { fsUpdater.setColumn('my_flag',count++) }