Table Node

Overview

Table nodes store Servoy specific information/functionality related to DB tables such as script calculations, aggregations and table events.

Properties Summarized

Type	Name	Summary
Object	columns

Events Summarized

Type	Name	Summary
void	onAfterCreate(record)	A method that is executed after a new record is created.
void	onAfterDelete(record)	A method that is executed after a delete operation.
void	onAfterFind()	A method that is executed after a foundset has switched to find mode.
void	onAfterInsert(record)	A method that is executed after an insert operation.
void	onAfterSearch()	A method that is executed after a search is executed for a foundset.
void	onAfterUpdate(record)	A method that is executed after an update operation.
Boolean	onCreate()	A method that is executed before a record is created.
Boolean	onDelete(record)	A method that is executed before a delete operation.
Boolean	onFind()	A method that is executed before a foundset is going into find mode.
void	onFoundSetLoad(memOrViewName)	A method that is executed when an in memory or viewfoundset table is first touched (by ui or scripting)
JSDataSet	onFoundsetNextChunk(inmemDataSourceName, sizeHint)	A method that can be used to load extra data in an in memory datasource.
Boolean	onInsert(record, recordMarkers, stateObject)	A method that is executed before an insert operation.
Boolean	onSearch(clearLastResults, reduceSearch)	A method that is executed before search() is called on a foundset in find mode.
Boolean	onUpdate(record, recordMarkers, stateObject)	A method that is executed before an update operation.
void	onValidate(record, recordMarkers, stateObject)	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

• Boolean clearLastResults ;

• Boolean reduceSearch ;

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

---