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.
Topic revision: r9 - 22 Apr 2018, GuidoBrugnara
This site is powered by FoswikiCopyright (©) Leader.IT - Italy P.I. IT01434390223 Privacy policy & use of cookies