Query Subroutines
Name |
Arguments |
Description |
Array2UpdateSql() |
|
The subroutine is used for updating or inserting records sent by GUI in an array format. The array is passed from gotoRecords method from the lib/databinding.js in the update parameter and it contains only record-sets of changed or inserted fields. The record-set exchanged between a server and a browser are in a array format with the Primary Key in the first column and fields in the same positions as defined with the FIELDS method from the .mql file. |
Call_OutFieldFilter() |
|
See the _OUT_FILTER method. |
Call_InFieldFilter |
|
If the _IN_FILTER method is defined, applies the filter to the specified field. |
EvalSqlWhere() |
|
|
ExecQuery() |
|
|
PrepareQuery() |
|
|
SelectWhere() |
|
|
SqlSelect() |
|
|
SqlWhere() |
|
|
str2sql_js_delimited() |
|
It returns a string adapted to be inserted into a SQL query, or to be inserted in a JavaScript code. |