servoy sReturnTypes2100%height: 30px;2Supported ClientssWordListSmartClientsWordListWebClientsWordListNGClientservoy sSummary12%30%58%height: 30px;3Methods SummaryCreates in this server a new table with the specified name.Drops the table with the specified name from this server.Returns a JSTable instance corresponding to the table with the specified name from this server.Returns an array with the names of all tables in this server.Get valid state for the server.voidReloads the datamodel from the database, if changed externally or via rawSQL plugin.Synchronizes a JSTable instance with the database.functionservoy sDetail2100%height:30px2Methods DetailscreateNewTablename
createNewTable(tableName)
dessIndent
Creates in this server a new table with the specified name.
prs
Parameters
sIndenttableNameThe name of the table to create.ret
Returns
sIndentJSTableObject created table.clients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowdropTablename
dropTable(tableName)
dessIndent
Drops the table with the specified name from this server.
prs
Parameters
sIndenttableNameThe name of the table to drop.ret
Returns
sIndentboolean success.clients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowgetTablename
getTable(tableName)
dessIndent
Returns a JSTable instance corresponding to the table with the specified name from this server.
prs
Parameters
sIndenttableNameThe name of the table to retrieve.ret
Returns
sIndentJSTableObject table.clients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowgetTableNamesname
getTableNames()
dessIndent
Returns an array with the names of all tables in this server.
ret
Returns
sIndentArray of String table names.clients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowisValidname
isValid()
dessIndent
Get valid state for the server.
ret
Returns
sIndentboolean valid state.clients
Supported Clients
sIndentSmartClient,WebClient,NGClientsam
Sample
sIdentjavascriptlastDetailRowreloadDataModelname
reloadDataModel()
dessIndent
Reloads the datamodel from the database, if changed externally or via rawSQL plugin.
This call is not needed after a call to synchronizeWithDB().
Synchronizes a JSTable instance with the database. If columns were added to or removed from the JSTable instance, all these changes will now be persisted to the database.
prs
Parameters
sIndenttableA JSTableObject instance that should be synchronized.ret