Query Subroutines

Name Arguments DescriptionSorted ascending
EvalSqlWhere()    
ExecQuery()    
PrepareQuery()    
SelectWhere()    
SqlSelect()    
SqlWhere()    
Call_InFieldFilter   If the _IN_FILTER method is defined, applies the filter to the specified field.
str2sql_js_delimited()   It returns a string adapted to be inserted into a SQL query, or to be inserted in a JavaScript code.
Call_OutFieldFilter()   See the _OUT_FILTER method.
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.
Topic revision: r9 - 22 Apr 2018, GuidoBrugnara
This site is powered by FoswikiCopyright (©) Leader.IT - Italy P.I. IT01434390223 Privacy policy & use of cookies