| Function Name | Description |
|---|---|
| Throw(message) (v2017+) | Throw an error message Parms message - error message |
| GetJavaScripts() (v2019+) | Get the list of JavaScript used as array |
| GetStyleSheets() (v2019+) | Get the list of StyleSheet used as array |
| IncludeTrailingPathDelimiter(path) (v2017+) | Return a path with trailing path delimiter Parms path - file path |
| GetLanguageFileId(file) (v2017+) | Return language file id Parms file - language file name |
| LinkDbExist(dbid) (v2017+) | Return if the link database exists Parms dbid - link database id |
| GetLinkDb(dbid) (v2017+) | Return link db object Parms dbid - link database id |
| GetDbId(tablename) (v12+) | Return database id for table name Parms tablename - table name |
| DbType(dbid) (v12+) | Return database type for database id Parms dbid - database id |
| MultiPageFldAttr(f) (v12+) | Return multi page field attribute Parms f - field object |
| MultiPageFldAttrValue(f) (v2017+) | Return multi page field attribute value Parms f - field object |
| IsDetailKeyFld(tbl, fld) (v12.0.3+) | Return if field is a detail key field Parms tbl - table object fld - field object |
| IsHiddenField(tbl, fld, id) (v12.0.3+) | Return if field is a hidden field Parms tbl - table object fld - field object id - add or edit |
| IsAutoSuggest(f) | Return if field is auto suggest Parms f - field object |
| UseForLabel(f) | Return if field uses for label Parms f - field object |
| HasUserTable() (v11+) | Return if user table is specified |
| IsEmpty(val) (v9+) | Return if value is empty Parms val - value |
| FormObj(ctlid) (v9+) | Return form object name Parms ctlid - control id |
| GetLanguageFieldProperty(lang, tbl, fld, propname) (v2019+) | Return field property for language Parms lang - language id tbl - table object fld - field object propname - field property name |
| GetLanguageFieldPhrase(lang, tblname, fieldname, propname) (v2017+) | Return language field phrase Parms lang - language id tblname - table name fieldname - field name propname - property name |
| RemoveAlias(fld) (v10+) | Remove Alias from field (i.e. <FIELD> AS <ALIAS> =>
<FIELD>) Parms fld - sql field |
| SelectFields(ar, idx, sep) (v9+) | Return SELECT field list from language field array Parms ar - field array idx - language index sep - field separator |
| SqlSelect(sSelectLimit, sDistinct, sSelect, sFrom) (v9+) | Return SQL SELECT statement Parms sSelectLimit - SELECT LIMIT part sDistinct - use SELECT DISTINCT sSelect - SELECT part sFrom - FROM part |
| CustomScriptRowCnt() (v9+) | Return custom template script id |
| CustomScriptRowStartVar() (v9+) | Return custom template row start variable |
| CustomScriptRowVar() (v9+) | Return custom template row variable |
| CustomScriptVar() (v9+) | Return custom template control variable |
| CustomScriptId(name, type ,idx) (v9+) | Return custom template script id Parms name - script name type - script type idx - row index (list/delete page) |
| CustomScriptTag(name, type, idx) (v9+) | Return custom template script tag Parms name - script name type - script type idx - row index (list/delete page) |
| GetJsScript(html) (v9+) | Return JavaScript from HTML Parms html - source HTML |
| RemoveJsScript(html) (v9+) | Remove JavaScript from HTML Parms html - source HTML |
| CastFieldForLike(tbl, fld, type, dateformat) (v9+) | Return SQL that cast non-string field for LIKE statement Parms tbl - table object fld - field SQL type - field type dateformat - date format |
| ContainsText(str, find) | Return if source string contains find string Parms str - source string find - find string |
| StartsText(str, find) | Return if source string starts with find string Parms str - source string find - find string |
| EndsText(str, find) | Return if source string ends with find string Parms str - source string find - find string |
| SameText(Str1, Str2) | Return if both string match (case insensitive) Parms Str1 - string 1 Str2 - string 2 |
| HasTagValue(fld, val) (v8.0+) | Return if field contains tag value Parms fld - field object val - tag value |
| FldTagValues(fld) (v8.0+) | Return field tag values Parms fld - field object |
| SplitTagValues(str) | Split tag values to array Parms str - field tag values |
| IsBinaryField(fld) | Return if field is binary field Parms fld - field object |
| GetTblObj(tablename) (v12.0+) | Return table object if exists. Otherwise return null. Parms tablename - table name |
| GetFldObj(t, fldname) (v2017+) | Return field object if exists. Otherwise return null. Parms t - table object fldname - field name |
| GetCtrlObj(ctrlId, ctrlTagExt) (v2017+) | Return control object if exists. Otherwise return null. Parms ctrlId - control id ctrlTagExt - control tag extension |
| GetParentSelect(f, i) (v12.0+) | Return parent select field Parms f - field object i - index (1-4) |
| GetParentSelectTbl(f, i) (v12.0+) | Return parent select table Parms f - field object i - index (1-4) |
| GetSelectFilter(f, pf) (v12.0.1+) | Return parent select filter field Parms f - field object pf - parent field name |
| GetExtObj(extname) (v2017+) | Return extension object if exists. Otherwise return null. Parms extname - extension name |
| GetExtTbl(extname, tblname) (v2017+) | Return extension table object if exists. Otherwise return null. Parms extname - extension name tblname - table name |
| GetExtFld(extname, tblname, fldname) (v2017+) | Return extension field object if exists. Otherwise return null. Parms extname - extension name tblname - table name fldname - field name |
| GetExtPrp(prps, prpid) (v2017+) | Return extension property value Parms prps - properties array prpid - property id |
| GetObjByName(name) (v2017+) | Return object Parms name - object name |
| CssInherit(val) | Return "inherit" if no value. Otherwise return original
value. Parms val - Css Value |
| RowCntVar(v) (v7.0+) | Return row object name (using RowCnt) Parms v - object name |
| RowCntVarQuoted(v) (v7.0+) | Return row object name (using RowCnt with quote) Parms v - object name |
| RowVar(v) | Return row object name Parms v - object name |
| RowVarQuoted(v) | Return row object name (with quote) Parms v - object name |
| RowVarToQuoted(v) | Return row object name (with quote and remove <?php echo ... ?>) Parms v - object name |
| AddSquareBrackets(varname, fld) | Add square brackets to variable Parms varname - variable name fld - field object |
| PageObj(ctlid) | Return page object name Parms ctlid - control id (optonal, if not specified, use CTRL.CtrlID) |
| PhpBool(v) (v2019+) | Return PHP TRUE/FALSE value Parms v - boolean value |
| JsBool(v) (v2019+) | Return JavaScript true/false value Parms v - boolean value |
| SecurityCheck(sId, bSecurity, bUserlevel) | Return Security Checking codes Parms sId - control id bSecurity - security is enabled bUserLevel - user level is enabled |
| PhpCode(php, typ) | Return codes in PHP tags (i.e. <?php ... ?>) Parms php - original PHP codes typ - return codes in PHP tags if = 0 |
| RandomKey() | Return random key |
| FolderPath(id) | Return folder path based on control id Parms id - control id |
| GetFileName(id, fn, tagext, path) (v2019+) | Return file name based on control id Parms id - control id fn - optional file name tagext - tag extension path - return file path also |
| RelFolder(f) | Return relative folder to current output folder Parms f - folder path |
| RelPath(f1, f2) | Return relative folder of f1 to f2 Parms f1 - folder path 1 f2 - folder path 2 |
| OutputRelPath(p) | Return output relative path Parms p - folder path |
| DestRelPath(p) | Return output path relative to Destination Parms p - folder path |
| AppRootRelPath(p) | Return output path relative to Application Root Parms p - folder path |
| DoubleQuote(str, cnt) | Return string with correct number of double quotes Parms str - source string cnt - number of double quotes (0,1) |
| Quote(str) | Escape double quote in string Parms str - source string |
| PhpQuote(str) | Escape double quote in string (including $ sign) Parms str - source string |
| SingleQuote(str) | Escape single quote in string Parms str - source string |
| Dequote(str) | Remove enclosing single/double quotes in string Parms str - source string |
| GetFieldType(ftype) | Return FIELD type based on ADO field type Parms ftype - ADO Field Type Output 1 - Numeric 2 - Date 3 - String 4 - Boolean 5 - GUID 6 - Others 7 - Time |
| BoolFieldTagValues(ftype, tagvalues) | Return tag values for Boolean field Parms ftype - ADO Field Type tagvalues - original tag values |
| SqlPart(sSQL, sId) | Return part of the SQL Parms sSQL - original SQL sId - token for different part of SQL (SELECT,FROM,WHERE,GROUP BY,HAVING,ORDER BY,LIMIT) |
| RecPerPageList(sList, iRec) | Return record per page list (comma separated) Parms sList - original record per page list iRec - default record per page |
| IsFldEncrypt(fld) (v2019+) | Return if field can be encrypted Parms fld - field object |
| IsFldFloatFormat(fld) (v9+) | Return if field is floating point type Parms fld - field object |
| IsFldVirtualLookup(fld) (v7.0+) | Return if field is a virtual lookup field Parms fld - field object |
| IsFldForceSelect(fld) (v8.0+) | Return if field is force select (auto suggest) Parms fld - field object |
| VirtualLookupFldSql(lang, fld, dbid) (v2019+) | Return the SQL for the virtual lookup field Parms lang = language id fld - field object dbid - database id |
| VirtualLookupFldName(fld, dbid) (v2019+) | Return the field name for the virtual lookup field Parms fld - field object dbid - database id |
| EscapeRegExChars(str) (v12.0+) | Escape the regular expression Parms str - regular expression string |
| QuotedName(name, dbid) (v12.0+) | Return the properly quoted sql name Parms name - table/field name dbid - database id |
| SqlConcatName(tbl, name1, name2, fld, idx) (v12+) | Return the concat sql name Parms tbl - table object name1 - field name 1 name2 - field name 2 fld - field object idx - language index |
| FieldSqlName(fld, dbid) (v12.0+) | Return the sql name for the field Parms fld - field object dbid - database id |
| CustomViewFieldName(fld, dbid) (v12.0+) | Return the field name for the field in the custom view Parms fld - field object dbid - database id |
| VirtualTableInCustomView(CustomSQL, TblName, dbid) (v12.0+) | Return if virtual table is in the custom view Parms CustomSQL - custom view SQL TblName - table name dbid - database id |
| EncodeName(Name) | Encode name in alphabeticnumeric Parms Name - Source name |
| CodeBaseExist(ScriptType, CodeType, Name) (v2017+) | Return if code base exists Parms ScriptType - script type CodeType - code type Name - script name |
| CodeBaseItem(ScriptType, CodeType, Name) (v2017+) | Return code base item Parms ScriptType - script type CodeType - code type Name - script name |
| CustomScriptExist(ScriptType, CodeType, Name, CtrlID, L1Key, L2Key) (v2017+) | Return if custom script exists Parms ScriptType - script type CodeType - code type Name - script name CtrlID - control id L1Key - table key L2Key - field key |
| ScriptItem(ScriptType, CodeType, Name, CtrlID, L1Key, L2Key) (v2017+) | Return custom script item Parms ScriptType - script type CodeType - code type Name - script name CtrlID - control id L1Key - table key L2Key - field key |
| ParseJson(json, reviver) (v2018+) | Parse and get JSON object Parms json - the string to parse as JSON reviver - reviver function (optional) |
| GetFieldJsonTypeName(FldTyp) (v2017+) | Get field json type name (number/string/boolean) Parms FldTyp - ADO field type |
| GetFieldTypeName(FldTyp) (v2017+) | Get PHPMaker data type name (EW_DATATYPE_*) Parms FldTyp - ADO field type |
| GetReturnPage(p) (v2017+) | Get return page Parms p - page name |
| LoadField(fldname) (v2017+) | Load field object by name Parms fldname - field name |
| GetFldVal(tbl, fld, fldtype) (v2017+) | Get field value expression Parms tbl - table object fld - field expression fldtype - field type |
| UseAddOpt() (v2017+) | Return if use add option |
| UseEmailExport() (v2017+) | Return if use email export |
| UseModalLookup() (v2017+) | Return if use modal lookup |
| IsExport() (v2017+) | Return if export is enabled |
| IsImport() (v2019+) | Return if import is enabled |
| UseTooltip() (v2017+) | Return if use tooltip |
| IsMasterDetail(master, detail) (v2017+) | Return if tables have master/detail relationship Parms master - master table name detail - detail table name |
| IsRelated(master, detail) (v2017+) | Return if tables are related (e.g. master table of master table) Parms master - master table name detail - detail table name |
| IsRequiredField(f) (v2017+) | Return if required field (i.e. NOT NULL) Parms f - field object |
| IsBoolFld(t, f) | Return if Boolean field Parms t - table object f - field object |
| IsValidateText(f) (v2017+) | Return if validate as TEXT field Parms f - field object |
| IsValidateFile(f) (v2017+) | Return if validate as file upload field Parms f - field object |
| IsValidateSearch(f) (v2017+) | Return if validate as search field Parms f - field object |
| IsValidateServer(f) (v2017+) | Return if validate on server side Parms f - field object |
| IsFldEditCtl(f) (v2017+) | Return if generate for edit Parms f - field object |
| IsFldList(f) (v2017+) | Return if generate for list Parms f - field object |
| IsFldReport(f) (v2017+) | Return if generate for report Parms f - field object |
| IsFldBasicSearch(f) (v2017+) | Return if generate for basic search Parms f - field object |
| IsFldExtendedSearch(f) (v2017+) | Return if generate for extended search Parms f - field object |
| IsFldAdvancedSearch(f) (v2017+) | Return if generate for advanced search Parms f - field object |
| IsFldUpdatable(f) (v2017+) | Return if field is updatable Parms f - field object |
| IsFldView(f) (v2017+) | Return if generate for view Parms f - field object |
| IsFldAdd(f) (v2017+) | Return if generate for add Parms f - field object |
| IsFldAddOpt(f) (v2017+) | Return if generate for add option Parms f - field object |
| IsFldEdit(f) (v2017+) | Return if generate for edit Parms f - field object |
| IsFldDelete(f) (v2017+) | Return if generate for delete Parms f - field object |
| IsFldUpdate(f) (v2017+) | Return if generate for multiple update Parms f - field object |
| IsFldRegister(f) (v2017+) | Return if generate for register Parms f - field object |
| IsCustomFld(f) (v2017+) | Return if field is a custom field Parms f - field object |
| ActivateFieldValue(t, f) (v2017+) | Get activate field value Parms t - table object f - field object |
| FieldStyle(f) (v2017+) | Get field style Parms f - field object |
| FieldHeaderAttributes(f) (v2017+) | Get field header attributes Parms f - field object |
| SqlTableName(t, dbid) (v2017+) | Get SQL for table Parms t - table object dbid - database id |
| BuildCond(cond, opr, newcond) (v2017+) | Get PHP condition expression Parms cond - original condition opr - and/or (&&/||) newcond - new condition |
| GetProjCssFileName() (v2017+) | Get project CSS file name |
| GetImageFolder() (v2017+) | Get image folder name |
| CharsetToIconvEncoding(Charset) (v2017+) | Get Iconv encoding from charset Parms Charset - charset name |
| CharsetToMySqlCharset(Charset) (v2017+) | Get MySQL charset from charset Parms Charset - charset name |
| CharsetToPostgreSqlCharset(Charset) (v2019+) | Get PostgreSql charset from charset Parms Charset - charset name |
| IsMsAccess() (v2017+) | Return if main database is MS Access |
| IsMsSQL() (v2017+) | Return if main database is Microsoft SQL Server |
| IsMySQL() (v2017+) | Return if main database is MySQL |
| IsPostgreSQL() (v2017+) | Return if main database is PostgreSQL |
| IsOracle() (v2017+) | Return if main database is Oracle |
| IsSQLite() (v2019+) | Return if main database is SQLite |
| GetOracleServiceName(ConnStr) (v2017+) | Get Oracle service name from connection string Parms ConnStr - connection string |
| UseADOdb() (v2017+) | Return if use ADOdb |
| GetMenuItems(isNavbar) (v2019+) | Return menu items as array Parms isNavbar - menu items for Navbar (true/false) |
| ProjNamespace() (v2019+) | Return project namespace |
| ScriptExist(ScriptType, CodeType, ScriptName) | Return if script exists Parms ScriptType - script type (Server / Client) CodeType - code type (Global / Table / Other) ScriptName - script name |
| ServerScriptExist(CodeType, ScriptName) | Return if server script exists |
| ClientScriptExist(CodeType, ScriptName) | Return if client script exists |
| CustomTemplateExist() (v9+) | Return if custom template exists |
| CustomMultiPageTemplateExist() (v9+) | Return if multi-page custom template Exists |
| CustomTemplateSearchExist() (v9+) | Return if list page custom search template exists |
| IsAggregate() | Return if aggregate is enabled |
| HasFileField() | Return if any file fields exist |
| IsMultiPage() | Return if multi-page is enabled |
| IsAutofillMasterField(ctlid) | Return if field is auto fill master field Parms ctlid - control id |
| IsFileRelatedField(fldname) | Return if field is file related field Parms fldname - field name |
| Function Name | Description |
|---|---|
| CharSet() | Return <meta> tag for charset specified |
| FavIcon() (v7.0+) | Return <link> tags for favicon specified |
| CSSFile() | Return <link> tag for css file specified |
| GetScript(ScriptType, CodeType, ScriptName) | Return server/client scripts Parms ScriptType - script type (Server / Client) CodeType - code type (Global / Table / Other) ScriptName - script name |
| GetTemplateScript(Type, Name) (v9+) | Return source custom template Parms Type - template type (Table / Other) Name - template name |
| GetServerScript(CodeType, ScriptName) | Return server scripts |
| GetClientScript(CodeType, ScriptName) | Return client scripts |
| CustomListOptions() (v9+) | Return custom template list option type (block/blocknotd/single) |
| GetCustomTemplate() (v9+) | Return translated custom template |
| GetCustomTemplatePage(pageid) (v9+) | Return translated custom template for page (multi-page layout) Parms pageid - page id (1/2/3/...) |
| ParseTemplate(template, id) (v9+) | Return translated template Parms template - source template id - template id |
| ParseFieldTemplate(template, src, id) (v2018+) | Return translated template Parms template - source template src - original code source id - template id |
| GetCustomTemplateSearch() (v9+) | Return translated list page custom search template |
| RenderCustomTemplate() (v9+) | Return rendering codes for custom template |
| RenderCustomTemplateSearch() (v9+) | Return rendering codes for list page custom search template |
| GetCustomViewTemplate(fld, src) (v9+) | Return custom view template for field Parms fld - field object src - original code source |
| GetCustomEditTemplate(fld, src, id) (v2018+) | Return custom edit template for field Parms fld - field object src - original code source id - template id |
| GetCustomViewTemplateExport(fld) (v9+) | Return custom view template for field (for export) Parms fld - field object |
| IncludeFile(fn, parm) | Return PHP include file statement Parms fn - file control id parm - extra parameter |
| Security() | Return PHP security checking codes |
| ScriptInsert() | Return PHP codes for inserting a record |
| ScriptUpdate() | Return PHP codes for updating a record |
| Script(ctlid) | Return PHP codes for inserting/updating a record Parms ctlid - "insert" / "update" |
| ScriptUpdateFile() | Return PHP codes to update files for file upload to folder |
| ScriptUpdateFileData(ctlid) Parms ctlid - "insert" / "update" |
Return PHP codes to prepare data for file upload to folder |
| ScriptUpdateSpecial() | Return PHP codes for updating detail key/parent/user id field |
| ScriptCommon() | Return PHP codes for rendering field (common) |
| ScriptViewRefer() | Return PHP codes for rendering field for VIEW (HREF) |
| ScriptAddRefer() | Return PHP codes for rendering field for ADD (HREF) |
| ScriptEditRefer() | Return PHP codes for rendering field for EDIT (HREF) |
| ScriptReferCall(cv, vv, ctlid) | Return PHP codes for rendering field for HREF Parms cv - current value vv - view value ctlid - control id |
| ScriptView() | Return PHP codes for rendering field for VIEW |
| ScriptViewCall(cv, vv) | Return PHP codes for rendering field for VIEW Parms cv - current value vv - view value |
| ScriptViewNo(cv, vv) | Return PHP codes for rendering field for VIEW (AutoNumber field) |
| ScriptViewText(cv, vv) | Return PHP codes for rendering field for VIEW (TEXT field) |
| ScriptViewHighlightSearch(cv, vv) | Return PHP codes for rendering field for search highlight |
| ScriptViewFormat(fld, parm) (v9+) | Return PHP codes to format field for VIEW Parms fld - field object parm - field to be formatted |
| ScriptViewPassword(cv, vv) | Return PHP codes for rendering field for VIEW (PASSWORD field) |
| ScriptViewRadio(cv, vv) | Return PHP codes for rendering field for VIEW (RADIO field) |
| ScriptViewTable(cv, vv, isedit) | Return PHP codes for rendering field for VIEW (Link to Table field) |
| ScriptViewValues(cv, vv) | Return PHP codes for rendering field for VIEW (Lookup Value field) |
| ScriptViewCheckbox(cv, vv) | Return PHP codes for rendering field for VIEW (CHECKBOX field) |
| ScriptViewSelect(cv, vv) | Return PHP codes for rendering field for VIEW (SELECT field) |
| ScriptViewTextarea(cv, vv) | Return PHP codes for rendering field for VIEW (TEXTAREA field) |
| ScriptViewHidden(cv, vv) | Return PHP codes for rendering field for VIEW (HIDDEN field) |
| ScriptViewFile(cv, vv) | Return PHP codes for rendering field for VIEW (FILE field) |
| ScriptViewHref(cv, vv, ctlid) | Return PHP codes for rendering field for VIEW (HREF field) |
| ScriptViewVirtual(wrk, vv) | Return PHP codes for rendering virtual lookup field Parms wrk - original rendering codes vv - view value |
| ScriptAdd() | Return PHP codes for rendering field for ADD |
| ScriptEdit() | Return PHP codes for rendering field for EDIT |
| ScriptEditCall(cv, ev, ctlid) | Return PHP codes for rendering field for ADD/EDIT/SEARCH Parms cv - current value ev - edit value ctlid - control id |
| ScriptEditFormat(ctl) (v9+) | Return PHP codes to format field for EDIT Parms ctl - control |
| ScriptSearch() | Return PHP codes for rendering field for SEARCH (Search Field 1) |
| ScriptSearch2() | Return PHP codes for rendering field for SEARCH (Search Field 2) |
| ScriptEditDefaultValue() | Return PHP codes for rendering field for Default Value |
| ScriptEditNo(cv, ev, ctlid) | Return PHP codes for rendering field for EDIT (AutoNumber field) |
| ScriptEditText(cv, ev, ctlid) | Return PHP codes for rendering field for EDIT (TEXT field) |
| ScriptEditPassword(cv, ev, ctlid) | Return PHP codes for rendering field for EDIT (PASSWORD field) |
| ScriptEditRadio(cv, ev, ctlid) | Return PHP codes for rendering field for EDIT (RADIO field) |
| ScriptEditTable(cv, ev, ctlid) | Return PHP codes for rendering field for EDIT (Link to Table field) |
| ScriptEditUserID(cv, ev, ctlid, userid) | Return PHP codes for rendering field for EDIT (User ID field) |
| ScriptEditValues(cv, ev, ctlid) | Return PHP codes for rendering field for EDIT (Lookup Value field) |
| ScriptEditCheckbox(cv, ev, ctlid) | Return PHP codes for rendering field for EDIT (CHECKBOX field) |
| ScriptEditSelect(cv, ev, ctlid) | Return PHP codes for rendering field for EDIT (SELECT field) |
| ScriptEditTextarea(cv, ev, ctlid) | Return PHP codes for rendering field for EDIT (TEXTAREA field) |
| ScriptEditHidden(cv, ev, ctlid) | Return PHP codes for rendering field for EDIT (HIDDEN field) |
| ScriptEditFile(cv, ev, ctlid) | Return PHP codes for rendering field for EDIT (FILE field) |
| ScriptAggregate() | Return PHP codes for rendering field for Aggregation |
| FieldCaption() | Return field caption |
| FieldSearchCaption() | Return field caption for search (list page) |
| FieldList() | Return field control for LIST |
| FieldAggregate() | Return field control for AGGREGATE |
| FieldView() | Return field control for VIEW |
| FieldViewCall(cv, vv, isedit) | Return field control for VIEW Parms cv - current value vv - view value isedit - edit mode |
| FieldViewCheckbox(cv, vv, isedit) | Return field control for VIEW (CHECKBOX field) |
| FieldViewFile(cv, vv, isedit) | Return field control for VIEW (FILE field) |
| FieldViewFileConfirm(cv, vv, isedit) | Return field control for confirm (FILE field) (deprecated) |
| FieldViewText(cv, vv, isedit) | Return field control for VIEW (TEXT field) |
| FieldViewHref(ctl) | Return field control for VIEW (HREF field) Parms ctl - control to be HREF |
| FieldUpdate() | Return field control for UPDATE |
| FieldEdit() | Return field control for EDIT |
| FieldEditPrimaryKey() | Return field control for EDIT (Primary Key field) |
| FieldEditDetailKey() | Return field control for EDIT (Detail Key field) |
| FieldAdd() | Return field control for ADD |
| FieldSearch() | Return field control for SEARCH (Search field 1) |
| FieldSearch2() | Return field control for SEARCH (Search field 2) |
| FieldEditCall(ctl, cv, ev, ctlid) | Return field control for EDIT Parms ctl - control cv - current value ev - edit value ctlid - control id |
| FieldEditNo(ctl, cv, ev, ctlid) | Return field control for EDIT (AutoNumber field) |
| FieldEditHidden(ctl, cv, ev, ctlid) | Return field control for EDIT (HIDDEN field) |
| FieldEditRadio(ctl, cv, ev, ctlid) | Return field control for EDIT (RADIO field) |
| FieldEditCheckbox(ctl, cv, ev, ctlid) | Return field control for EDIT (CHECKBOX field) |
| FieldEditPassword(ctl, cv, ev, ctlid) | Return field control for EDIT (PASSWORD field) |
| FieldEditSelect(ctl, cv, ev, ctlid) | Return field control for EDIT (SELECT field) |
| FieldEditDynamicSelect(ctl, cv, ev, ctlid) | Return field control for EDIT (Dynamic SELECT field) |
| FieldEditAjaxSelect(ctl, cv, ev, ctlid) | Return field control for EDIT (Ajax SELECT field) |
| FieldEditAutofill(ctl, cv, ev, ctlid) | Return field control for EDIT (Auto Fill field) |
| FieldEditFile(ctl, cv, ev, ctlid) | Return field control for EDIT (FILE field) |
| FieldEditText(ctl, cv, ev, ctlid) | Return field control for EDIT (TEXT field) |
| FieldEditTextarea(ctl, cv, ev, ctlid) | Return field control for EDIT (TEXTAREA field) |
| FieldEditUserTablePassword(ctl, cv, ev, ctlid) | Return field control for EDIT (user table password field) |
| FieldEditLookup(ctl, cv, ev, ctlid) (v2017+) | Return field control for EDIT (modal lookup field) |
| FieldOperator() | Return field control for search operator 1 |
| FieldOperator2() | Return field control for search operator 2 |
| FieldOperatorCall(ctl, val, opr) | Return field control for search operator Parms ctl - control val - search value opr - operator |
| FieldSearchCondition() | Return field control for search condition (BETWEEN or 2nd Opr enabled) |
| OrderByFieldSources() | Return ORDER BY field sources (comma separated) |
| JsReqValidator() | Return JS validator for required field |
| JsReqErrMsg() | Return JS error message for required field |
| JsValidator() | Return JS validator |
| JsDefaultMsg() | Return default JS error message |
| PhpReqValidator() | Return PHP validator for required field |
| PhpReqErrMsg() | Return PHP error message for required field |
| PhpReqDefaultMsg() | Return default PHP error message for required field |
| PhpSearchValidator() | Return PHP validator for search field |
| PhpValidator() | Return PHP validator |
| PhpFileValidator() | Return PHP validator for file type |
| PhpValidatorCommon(fld, msg) | Return PHP validator Parms fld - field msg - message |
| PhpErrMsg() | Return PHP error message |
| PhpDefaultMsg() | Return default PHP error message |
| ConnectionString(db) (v12.0+) | Return database connection string Parms db - database object |
| DatabaseConnection(db) (v12.0+) | Return database connection array Parms db - database object |
| LookupSettings(lang) (v2019+) | Return lookup settings Parms lang - language id |