Table Node
Overview
Table nodes store Servoy specific information/functionality related to DB tables such as script calculations, aggregations and table events.
Properties Summarized
Events Summarized
| Type | Name | Summary |
|---|---|---|
void | A method that is executed after a new record is created. | |
void | A method that is executed after a delete operation. | |
void | A method that is executed after a foundset has switched to find mode. | |
void | A method that is executed after an insert operation. | |
void | A method that is executed after a search is executed for a foundset. | |
void | A method that is executed after an update operation. | |
A method that is executed before a record is created. | ||
A method that is executed before a delete operation. | ||
A method that is executed before a foundset is going into find mode. | ||
void | A method that is executed when an in memory or viewfoundset table is first touched (by ui or scripting) | |
A method that can be used to load extra data in an in memory datasource. | ||
A method that is executed before an insert operation. | ||
A method that is executed before search() is called on a foundset in find mode. | ||
A method that is executed before an update operation. | ||
void | A method that is executed before an insert operation. |
Properties Detailed
columns
Type Object
Events Detailed
onAfterCreate(record)
A method that is executed after a new record is created.
Parameters
JSRecord record record that is created
Returns: void
onAfterDelete(record)
A method that is executed after a delete operation.
Parameters
JSRecord record record that is deleted
Returns: void
onAfterFind()
A method that is executed after a foundset has switched to find mode.
Returns: void
onAfterInsert(record)
A method that is executed after an insert operation.
Parameters
JSRecord record record that is inserted
Returns: void
onAfterSearch()
A method that is executed after a search is executed for a foundset.
Returns: void
onAfterUpdate(record)
A method that is executed after an update operation.
Parameters
JSRecord record record that is updated
Returns: void
onCreate()
A method that is executed before a record is created. The method can block the creation by returning false.
Returns: Boolean
onDelete(record)
A method that is executed before a delete operation. The method can block the delete operation by returning false.
Parameters
JSRecord record record that will be deleted
Returns: Boolean
onFind()
A method that is executed before a foundset is going into find mode. The method can block the mode change.
Returns: Boolean
onFoundSetLoad(memOrViewName)
A method that is executed when an in memory or viewfoundset table is first touched (by ui or scripting)
Parameters
String memOrViewName The in memory or view foundset table name that is touched.
Returns: void
onFoundsetNextChunk(inmemDataSourceName, sizeHint)
A method that can be used to load extra data in an in memory datasource.
This method id called when the inMem datasource is fully read.
Parameters
String inmemDataSourceName name of the inmemory datasource.
Number sizeHint preferred number of records to be retrieved.
Returns: JSDataSet
onInsert(record, recordMarkers, stateObject)
A method that is executed before an insert operation. The method can block the insert operation by returning false.
Parameters
JSRecord record record that will be inserted
JSRecordMarkers recordMarkers the object where all the problems can be reported against
Object stateObject an object that a user can give to validateRecord for extra state (optional, can be null).
Returns: Boolean
onSearch(clearLastResults, reduceSearch)
A method that is executed before search() is called on a foundset in find mode. The method can block the search (foundset will stay in find mode).
Parameters
Returns: Boolean
onUpdate(record, recordMarkers, stateObject)
A method that is executed before an update operation. A method can block the update by returning false.
Parameters
JSRecord record record that will be updated
JSRecordMarkers recordMarkers the object where all the problems can be reported against
Object stateObject an object that a user can give to validateRecord for extra state (optional, can be null).
Returns: Boolean
onValidate(record, recordMarkers, stateObject)
A method that is executed before an insert operation. The method can block the insert operation by returning false.
Parameters
JSRecord record record that must be validated
JSRecordMarkers recordMarkers the object where all the problems can be reported against.
Object stateObject an object that a user can give to validateRecord for extra state (optional, can be null).
Returns: void
Last updated