Table Row (tr) |
---|
| Table Head (th) |
---|
| Method Summary |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#acquireLockacquireLock(foundset, recordIndex) Request lock(s) for a foundset, can be a normal or related foundset. |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#acquireLockacquireLock(foundset, recordIndex, lockName) Request lock(s) for a foundset, can be a normal or related foundset. |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#convertFoundSetconvertFoundSet(foundset, related) Creates a foundset that combines all the records of the specified one-to-many relation seen from the given parent/primary foundset. |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#convertFoundSetconvertFoundSet(foundset, related) Creates a foundset that combines all the records of the specified one-to-many relation seen from the given parent/primary foundset. |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#copyMatchingFieldscopyMatchingFields(source, destination) Copies all matching non empty columns (if overwrite boolean is given all columns except pk/ident, if array then all columns except pk and array names). |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#copyMatchingFieldscopyMatchingFields(source, destination, overwrite) Copies all matching non empty columns (if overwrite boolean is given all columns except pk/ident, if array then all columns except pk and array names). |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#copyMatchingFieldscopyMatchingFields(source, destination, names) Copies all matching non empty columns (if overwrite boolean is given all columns except pk/ident, if array then all columns except pk and array names). |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
createDataSourceByQuery(name, query, max_returned_rows) Performs a query and saves the result in a datasource. |
|
Table Row (tr) |
---|
| tbodycreateDataSourceByQuery(name, server_name, sql_query, arguments, max_returned_rows, types, pkNames) Performs a sql query on the specified server, saves the the result in a datasource. |
|
Table Row (tr) |
---|
Table Cell (td) |
---|
#getDataSetByQuerygetDataSetByQuery(server_name, sql_query, arguments, max_returned_rows) Performs a sql query on the specified server, returns the result in a dataset. |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#getFoundSetgetFoundSet(dataSource) Returns a foundset object for a specified datasource or server and tablename. |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#getFoundSetgetFoundSet(serverName, tableName) Returns a foundset object for a specified datasource or server and tablename. |
| tbody |
Table Body (tbody) |
---|
Table Row (tr) |
---|
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#getNextSequencegetNextSequence(dataSource, columnName) Gets the next sequence for a column which has a sequence defined in its column dataprovider properties. |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#getSQLgetSQL(foundset) Returns the internal SQL which defines the specified (related)foundset. |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#getSQLgetSQL(foundset, includeFilters) Returns the internal SQL which defines the specified (related)foundset. |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#getSQLParametersgetSQLParameters(foundset, includeFilters) Returns the internal SQL parameters, as an array, that are used to define the specified (related)foundset. |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#getTablegetTable(foundset) Returns the JSTable object from which more info can be obtained (like columns). |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#getTablegetTable(record) Returns the JSTable object from which more info can be obtained (like columns). |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#getTablegetTable(dataSource) Returns the JSTable object from which more info can be obtained (like columns). |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#getTablegetTable(serverName, tableName) Returns the JSTable object from which more info can be obtained (like columns). |
| tbody |
Table Body (tbody) |
---|
Table Row (tr) |
---|
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#hasLockshasLocks() Returns true if the current client has any or the specified lock(s) acquired. |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#hasLockshasLocks(lockName) Returns true if the current client has any or the specified lock(s) acquired. |
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
Table Cell (td) |
---|
#hasNewRecordshasNewRecords(foundset) Returns true if the argument (foundSet / record) has at least one row that was not yet saved in the database. |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#hasNewRecordshasNewRecords(foundset, index) Returns true if the argument (foundSet / record) has at least one row that was not yet saved in the database. |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#hasRecordChangeshasRecordChanges(foundset) Returns true if the specified foundset, on a specific index or in any of its records, or the specified record has changes. |
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
Table Cell (td) |
---|
#hasRecordChangeshasRecordChanges(foundset, index) Returns true if the specified foundset, on a specific index or in any of its records, or the specified record has changes. |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#hasRecordshasRecords(foundset) Returns true if the (related)foundset exists and has records. |
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
Table Cell (td) |
---|
#hasRecordshasRecords(record, relationString) Returns true if the (related)foundset exists and has records. |
|
Table Body (tbody) |
---|
Table Row (tr) |
---|
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#mergeRecordsmergeRecords(sourceRecord, combinedDestinationRecord) Merge records from the same foundset, updates entire datamodel (via foreign type on columns) with destination record pk, deletes source record. |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#mergeRecordsmergeRecords(sourceRecord, combinedDestinationRecord, columnNames) Merge records from the same foundset, updates entire datamodel (via foreign type on columns) with destination record pk, deletes source record. |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#recalculaterecalculate(foundsetOrRecord) Can be used to recalculate a specified record or all rows in the specified foundset. |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#saveDatasaveData() Saves all outstanding (unsaved) data and exits the current record. |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#saveDatasaveData(foundset) Saves all outstanding (unsaved) data and exits the current record. |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#saveDatasaveData(record) Saves all outstanding (unsaved) data and exits the current record. |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#setAutoSavesetAutoSave(autoSave) Set autosave, if false then no saves will happen by the ui (not including deletes!). |
| tbody |
Table Row (tr) |
---|
Table Cell (td) |
---|
#switchServerswitchServer(sourceName, destinationName) Switches a named server to another named server with the same datamodel (recommended to be used in an onOpen method for a solution). |
|
|