Table Head (thead) |
---|
Table Row (tr) |
---|
| Table Head (th) |
---|
| Method Details |
|
|
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Go to next record in this updater, returns true if successful. |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Div |
---|
| Boolean - true if proceeded to next record, false otherwise |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| controller.setSelectedIndex(1)
var count = 0
var fsUpdater = databaseManager.getFoundSetUpdater(foundset)
while(fsUpdater.next())
{
fsUpdater.setColumn('my_flag',count++)
} |
|
|
|
|
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=342FD487-266A-420F-8ACA-D482F58038C2}{tr:id=name}{td}h6.performUpdate{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}performUpdate{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:342FD487-266A-420F-8ACA-D482F58038C2_des|text=|trigger=button}{sub-section}{sub-section:342FD487-266A-420F-8ACA-D482F58038C2_des|trigger=none|class=sIndent}Do the actual update in the database, returns true if successful.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:342FD487-266A-420F-8ACA-D482F58038C2_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:342FD487-266A-420F-8ACA-D482F58038C2_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:342FD487-266A-420F-8ACA-D482F58038C2_ret|text=|trigger=button}{sub-section}{sub-section:342FD487-266A-420F-8ACA-D482F58038C2_ret|trigger=none|class=sIndent}[Boolean] -- true if succeeded, false if failed.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:342FD487-266A-420F-8ACA-D482F58038C2_see|text=|trigger=button}{sub-section}{sub-section:342FD487-266A-420F-8ACA-D482F58038C2_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:342FD487-266A-420F-8ACA-D482F58038C2_see|text=|trigger=button}{sub-section}{sub-section:342FD487-266A-420F-8ACA-D482F58038C2_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:342FD487-266A-420F-8ACA-D482F58038C2_sam|text=|trigger=button}{sub-section}{sub-section:342FD487-266A-420F-8ACA-D482F58038C2_sam|class=sIndent|trigger=none}{code:language=javascript}
//There are 3 types of possible use with the foundset updater
// Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| 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 by a single sql statement; that is not possible when the table of the foundset has tracking enabled then it will loop over the whole foundset. When a single sql statement is done, modification columns will not be updated, because it does the update directly in the database, without getting the records. 2) update part of foundset, for example the first 4 row (starts with selected row) 3) safely loop through foundset (starts with selected row) after the perform update call there are no records in edit mode, that where not already in edit mode, because all of them are saved directly to the database, or in mode 1 the records are not touched at all and the database is updated directly. |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Div |
---|
| Boolean - true if succeeded, false if failed. |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| //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++)
} |
|
|
|
|
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=F4170BDC-4F62-4C71-8AD3-7EC5E191AC21}{tr:id=name}{td}h6.resetIterator{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}void{span}{span:id=iets|style=float: left; font-weight: bold;}resetIterator{span}{span:id=iets|style=float: left;}\(){span}{td}{tr}{tr:id=des}{td}{sub-section:F4170BDC-4F62-4C71-8AD3-7EC5E191AC21_des|text=|trigger=button}{sub-section}{sub-section:F4170BDC-4F62-4C71-8AD3-7EC5E191AC21_des|trigger=none|class=sIndent}Start over with this iterator 'next' function (at the foundset selected record).{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=prs}{td}*Parameters*\\{sub-section:F4170BDC-4F62-4C71-8AD3-7EC5E191AC21_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:F4170BDC-4F62-4C71-8AD3-7EC5E191AC21_prs|trigger=none}{sub-section}{div}{td}{tr}{builder-show}{tr:id=ret}{td}*Returns*\\{sub-section:F4170BDC-4F62-4C71-8AD3-7EC5E191AC21_ret|text=|trigger=button}{sub-section}{sub-section:F4170BDC-4F62-4C71-8AD3-7EC5E191AC21_ret|trigger=none|class=sIndent}void{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:F4170BDC-4F62-4C71-8AD3-7EC5E191AC21_see|text=|trigger=button}{sub-section}{sub-section:F4170BDC-4F62-4C71-8AD3-7EC5E191AC21_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:F4170BDC-4F62-4C71-8AD3-7EC5E191AC21_see|text=|trigger=button}{sub-section}{sub-section:F4170BDC-4F62-4C71-8AD3-7EC5E191AC21_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:F4170BDC-4F62-4C71-8AD3-7EC5E191AC21_sam|text=|trigger=button}{sub-section}{sub-section:F4170BDC-4F62-4C71-8AD3-7EC5E191AC21_sam|class=sIndent|trigger=none}{code:language=javascript}
Table Body (tbody) |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
resetIterator |
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Start over with this iterator 'next' function (at the foundset selected record). |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| 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)
} |
|
|
|
|
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{tbody:id=1E461551-0AD6-46C4-9BF3-CBAED31AD563}{tr:id=name}{td}h6.setColumn{td}{tr}{tr:id=sig}{td}{span:style=float: left; margin-right: 5px;}[Boolean]{span}{span:id=iets|style=float: left; font-weight: bold;}setColumn{span}{span:id=iets|style=float: left;}\(name, value){span}{td}{tr}{tr:id=des}{td}{sub-section:1E461551-0AD6-46C4-9BF3-CBAED31AD563_des|text=|trigger=button}{sub-section}{sub-section:1E461551-0AD6-46C4-9BF3-CBAED31AD563_des|trigger=none|class=sIndent}Set the column value to update, returns true if successful.{sub-section}{td}{tr}{tr:id=prs}{td}*Parameters*\\{sub-section:1E461551-0AD6-46C4-9BF3-CBAED31AD563_prs|text=|trigger=button}{sub-section}{div:class=sIndent}{sub-section:1E461551-0AD6-46C4-9BF3-CBAED31AD563_prs|trigger=none}name -- The name of the column to update.
value -- The new value to be stored in the specified column.
{sub-section}{div}{td}{tr}{tr:id=ret}{td}*Returns*\\{sub-section:1E461551-0AD6-46C4-9BF3-CBAED31AD563_ret|text=|trigger=button}{sub-section}{sub-section:1E461551-0AD6-46C4-9BF3-CBAED31AD563_ret|trigger=none|class=sIndent}[Boolean] -- true if succeeded, false if failed.{sub-section}{td}{tr}{builder-show:permission=edit}{tr:id=see}{td}*Also see*\\{sub-section:1E461551-0AD6-46C4-9BF3-CBAED31AD563_see|text=|trigger=button}{sub-section}{sub-section:1E461551-0AD6-46C4-9BF3-CBAED31AD563_see|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{builder-show:permission=edit}{tr:id=link}{td}*External links*\\{sub-section:1E461551-0AD6-46C4-9BF3-CBAED31AD563_see|text=|trigger=button}{sub-section}{sub-section:1E461551-0AD6-46C4-9BF3-CBAED31AD563_link|class=sIndent|trigger=none}{sub-section}{td}{tr}{builder-show}{tr:id=sam}{td}*Sample*\\{sub-section:1E461551-0AD6-46C4-9BF3-CBAED31AD563_sam|text=|trigger=button}{sub-section}{sub-section:1E461551-0AD6-46C4-9BF3-CBAED31AD563_sam|class=sIndent|trigger=none}{code:language=javascript}
//There are 3 types of possible use with the foundset updater
Table Body (tbody) |
---|
id | setColumn-String_Object |
---|
| Table Row (tr) |
---|
| Table Cell (td) |
---|
Div |
---|
| Set the column value to update, returns true if successful. |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Parameters Div |
---|
| {String} name - The name of the column to update. {Object} value - The new value (can be an array with data for x number of rows) to be stored in the specified column. |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Returns Div |
---|
| Boolean - true if succeeded, false if failed. |
|
|
Table Row (tr) |
---|
| Table Cell (td) |
---|
Sample Div |
---|
| Code Block |
---|
| //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++)
} |
|
|
|
|
{code}{sub-section}{td}{tr}{tr:class=lastDetailRow}{td}{td}{tr}{tbody}{table} |