Page History
Divcache | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
Div | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
Excerpt Include | The Servoy Foundset | The Servoy Foundset | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
nopanel | true | |||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
HTML Table | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
id | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
class | servoy sSummary |
Colgroup Tag | |||||
---|---|---|---|---|---|
|
Table Head (thead) | ||||||||||
---|---|---|---|---|---|---|---|---|---|---|
|
Table Cell (td) |
---|
Boolean |
indexstyle | true | display:none |
---|
DO NOT EDIT THE CONTENT OF THIS PAGE DIRECTLY (EXCEPT INSIDE THE DIV BELOW WITH ID=DESCRIPTION), UNLESS YOU KNOW WHAT YOU'RE DOING.
THE STRUCTURE OF THE CONTENT IS VITAL IN BEING ABLE TO AUTO UPDATE THE CONTENT THROUGH THE DOC GENERATOR.
refresh | 100d |
---|---|
showRefresh | true |
id | doc |
title | Refresh page |
showDate | true |
retry | Enable |
Table Cell (td) |
---|
Boolean |
Table Cell (td) |
---|
Boolean |
Col |
---|
Table Head (th) | ||
---|---|---|
| ||
Method Details |
id | next |
---|
Table Row (tr) | ||
---|---|---|
| ||
|
Table Row (tr) | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
id | ret |
---|
Returns
class | sIndent |
---|
id | ret |
---|
Returns
class | sIndent |
---|
next()
Go to next record in this updater, returns true if successful.
NOTE: this method doesn't take into account deletes and inserts that may happen at same time. For more reliable iterator see foundset.forEach
Returns
Table Row (tr) | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
|
Table Row (tr) | ||
---|---|---|
| ||
|
id | performUpdate |
---|
Table Row (tr) | ||
---|---|---|
| ||
|
Table Row (tr) | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
Table Body (tbody) | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
|
id | setColumn-String_Object |
---|
Table Row (tr) | ||
---|---|---|
| ||
|
Table Row (tr) | ||||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||||
|
Table Row (tr) | |||||||
---|---|---|---|---|---|---|---|
| |||||||
|
id | prs |
---|
Parameters
class | sIndent |
---|
Supported Clients
Sample
performUpdate()
Do the actual update in the database, returns true if successful. It will first try to save all editing records (from all foundsets), if cannot save will return false before doing the update.
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 and associated Table Events won't be triggered, because it does the update directly in the database, without getting the records.
NOTE: this mode will refresh all foundsets based on same datasource
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.
Returns
Table Row (tr) | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
|
Table Row (tr) | ||
---|---|---|
| ||
|
Supported Clients
Sample
resetIterator()
Start over with this iterator 'next' function (at the foundset selected record).
Supported Clients
Sample
setColumn(name, value)
Set the column value to update, returns true if successful.
Parameters
{Object}
Returns
class | lastDetailRow |
---|
Table Row (tr) | ||||||||||||
---|---|---|---|---|---|---|---|---|---|---|---|---|
| ||||||||||||
|
Supported Clients
Sample