The following details provide a set of functions to query, insert, update and delete rows from custom tables.
executeSimpleQuery
It returns a structure containing the result of the query execution.
| Parameter | Type | Description |
|---|---|---|
| query | String | See this page for further details. |
| options | List of <Option> |
Return values: SimpleQueryResult
Permissions: access restricted according to the permission set for the custom table.
executeUpdate
It executes an update query on a custom table (query must be one of "UPDATE.. ", "INSERT.. " or "DELETE. ")
In order to perform large volumes updates/inserts on custom tables use the asynchronous functions
| Parameter | Type | Description |
|---|---|---|
| query | String | See this page for further details. |
| options | List of <Option> |
Return values: the number of records inserted/updated/deleted
Permissions: access restricted according to the permission set for the custom table.
executeSql
It executes an SQL query in a more versatile way then executesimplequery and executeupdate.
| Parameter | Type | Description |
|---|---|---|
| query | String | SELECT * FROM CONTACTS WHERE name = ? |
| options | List of <Option> | Max (integer): maximum number of records to be returned (it works only with select type queries) |
| parameters | List of <SQLParameter> | Supported parameters are string, integer, number, timestamp, null. For timestamp the value has to be the amount of milliseconds from the UNIX epoch (January 1, 1970, 00:00:00 GMT). |
Return values: sqlResult
Permissions: access restricted according to the permission set for the custom table.