1. System Functions (Common utility functions)

USAGE: <FunctionName>

Function Name Description
ew_Throw(message) (v2017+) Throw an error message
Parms
 message - error message
ew_GetJavaScriptArray() (v2018+) Get the list of JavaScript used as array
ew_GetStyleSheetArray() (v2018+) Get the list of StyleSheet used as array
ew_IncludeTrailingPathDelimiter(path) (v2017+) Return a path with trailing path delimiter
Parms
 path - file path
ew_GetLanguageFileId(file) (v2017+) Return language file id
Parms
 file - language file name
ew_LinkDBExist(dbid) (v2017+) Return if the link database exists
Parms
 dbid - link database id
ew_GetLinkDB(dbid) (v2017+) Return link db object
Parms
 dbid - link database id
ew_GetDbId(tablename) (v12+) Return database id for table name
Parms
 tablename - table name
ew_DbType(dbid) (v12+) Return database type for database id
Parms
 dbid - database id
ew_MultiPageFldAttr(f) (v12+) Return multi page field attribute
Parms
 f - field object
ew_MultiPageFldAttrValue(f) (v2017+) Return multi page field attribute value
Parms
 f - field object
ew_IsDetailKeyFld(tbl, fld) (v12.0.3+) Return if field is a detail key field
Parms
 tbl - table object
 fld - field object
ew_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
ew_IsAutoSuggest(f) Return if field is auto suggest
Parms
 f - field object
ew_UseForLabel(f) Return if field uses for label
Parms
 f - field object
ew_HasUserTable() (v11+) Return if user table is specified
ew_IsNotEmpty(val) (v9+) Return if value is not empty
Parms
 val - value
ew_IsEmpty(val) (v9+) Return if value is empty
Parms
 val - value
ew_FormObj(ctlid) (v9+) Return form object name
Parms
 ctlid - control id
ew_GetLanguageFields(tbl, fld, name) (v9+) Return field array for multi-language
Parms
 tbl - table object
 fld - field object
 name - field property name
ew_GetLanguageFieldPhrase(lang, tblname, fieldname, propname) (v2017+) Return language field phrase
Parms
 lang - language
 tblname - table name
 fieldname - field name
 propname - property name
ew_SelectFieldName(arflds, idx) (v9+) Return SELECT field from language field array
Parms
 arflds - field array
 idx - language index
ew_AddSelectField(ar, tbl, arflds, cnt, alias) (v9+) Add SELECT fields to field array
Parms
 ar - field array
 tbl - table object
 arflds - language field array
 cnt - language count
 alias - field alias
ew_RemoveAlias(fld) (v10+) Remove Alias from field (i.e. <FIELD> AS <ALIAS> => <FIELD>)
Parms
 fld - sql field
ew_SelectFields(ar, idx, sep) (v9+) Return SELECT field list from language field array
Parms
 ar - field array
 idx - language index
 sep - field separator
ew_DisplayFieldFilters(t, f, idx) (v2017+) Return display field filters
Parms
 t - table object
 f - field object
 idx - language index
ew_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
ew_CustomScriptRowCnt() (v9+) Return custom template script id
ew_CustomScriptRowStartVar() (v9+) Return custom template row start variable
ew_CustomScriptRowVar() (v9+) Return custom template row variable
ew_CustomScriptVar() (v9+) Return custom template control variable
ew_CustomScriptId(name, type ,idx) (v9+) Return custom template script id
Parms
 name - script name
 type - script type
 idx - row index (list/delete page)
ew_CustomScriptTag(name, type, idx) (v9+) Return custom template script tag
Parms
 name - script name
 type - script type
 idx - row index (list/delete page)
ew_GetJsScript(html) (v9+) Return JavaScript from HTML
Parms
 html - source HTML
ew_RemoveJsScript(html) (v9+) Remove JavaScript from HTML
Parms
 html - source HTML
ew_CastFieldForLike(tbl, fld, type) (v9+) Return SQL that cast non-string field for LIKE statement
Parms
 tbl - table object
 fld - field SQL
 type - field type
ew_ContainsText(str, find) Return if source string contains find string
Parms
 str - source string
 find - find string
ew_SameText(Str1, Str2) Return if both string match (case insensitive)
Parms
 Str1 - string 1
 Str2 - string 2
ew_HasTagValue(fld, val) (v8.0+) Return if field contains tag value
Parms
 fld - field object
 val - tag value
ew_FldTagValues(fld) (v8.0+) Return field tag values
Parms
 fld - field object
ew_SplitTagValues(str) Split tag values to array
Parms
 str - field tag values
ew_IsBinaryField(fld) Return if field is binary field
Parms
 fld - field object
ew_ImageViewUrl(tblvar, fld, bQuoted) Return image view url
Parms
 tblvar - table variable
 fld - field object
 bQuoted - return as quoted string
ew_GetTblObj(tablename) (v12.0+) Return table object if exists. Otherwise return null.
Parms
 tablename - table name
ew_GetFldObj(t, fldname) (v2017+) Return field object if exists. Otherwise return null.
Parms
 t - table object
 fldname - field name
ew_GetCtrlObj(ctrlid) (v2017+) Return control object if exists. Otherwise return null.
Parms
 ctrlid - control id
ew_GetParentSelect(f, i) (v12.0+) Return parent select field
Parms
 f - field object
 i - index (1-4)
ew_GetParentSelectTbl(f, i) (v12.0+) Return parent select table
Parms
 f - field object
 i - index (1-4)
ew_GetSelectFilter(f, pf) (v12.0.1+) Return parent select filter field
Parms
 f - field object
 pf - parent field name
ew_GetExtObj(extname) (v2017+) Return extension object if exists. Otherwise return null.
Parms
 extname - extension name
ew_GetExtTbl(extname, tblname) (v2017+) Return extension table object if exists. Otherwise return null.
Parms
 extname - extension name
 tblname - table name
ew_GetExtFld(extname, tblname, fldname) (v2017+) Return extension field object if exists. Otherwise return null.
Parms
 extname - extension name
 tblname - table name
 fldname - field name
ew_GetExtPrp(prps, prpid) (v2017+) Return extension property value
Parms
 prps - properties array
 prpid - property id
ew_GetObjByName(name) (v2017+) Return object
Parms
 name - object name
ew_CssInherit(val) Return "inherit" if no value. Otherwise return original value.
Parms
 val - Css Value
ew_RowCntVar(v) (v7.0+) Return row object name (using RowCnt)
Parms
 v - object name
ew_RowCntVarQuoted(v) (v7.0+) Return row object name (using RowCnt with quote)
Parms
 v - object name
ew_RowVar(v) Return row object name
Parms
 v - object name
ew_RowVarQuoted(v) Return row object name (with quote)
Parms
 v - object name
ew_RowVarToQuoted(v) Return row object name (with quote and remove <?php echo ... ?>)
Parms
 v - object name
ew_AddSquareBrackets(varname, fld) Add square brackets to variable
Parms
 varname - variable name
 fld - field object
ew_PageObj() Return page object name
ew_GetPageObjByCtrlId(ctlid) (v8.0+) Return page object name based on control id
Parms
 ctlid - control id
ew_GetCtrlById(id) (v8.0+) Return control object based on control id
Parms
 ctlid - control id
ew_Val(v) (v7.0+) Return PHP TRUE/FALSE value
Parms
 v - boolean value
ew_JsVal(v) (v7.0+) Return JavaScript true/false value
Parms
 v - boolean value
ew_SecurityCheck(sId, bSecurity, bUserlevel) Return Security Checking codes
Parms
 sId - control id
 bSecurity - security is enabled
 bUserLevel - user level is enabled
ew_PhpCode(php, typ) Return codes in PHP tags (i.e. <?php ... ?>)
Parms
 php - original PHP codes
 typ - return codes in PHP tags if = 0
ew_RandomKey() Return random key
ew_FolderPath(id) Return folder path based on control id
Parms
 id - control id
ew_GetFileNameByCtrlID(id) Return file name based on control id
Parms
 id - control id
ew_RelFolder(f) Return relative folder to current output folder
Parms
 f - folder path
ew_RelPath(f1, f2) Return relative folder of f1 to f2
Parms
 f1 - folder path 1
 f2 - folder path 2
ew_OutputRelPath(p) Return output relative path
Parms
 p - folder path
ew_DestRelPath(p) Return output path relative to Destination
Parms
 p - folder path
ew_AppRootRelPath(p) Return output path relative to Application Root
Parms
 p - folder path
ew_EscapeString(sSrc, sEsc) Return escaped string
Parms
 sSrc - source string
 sEsc - escape type (double quote for VB, back slash for js)
ew_DoubleQuote(str, cnt) Return string with correct number of double quotes
Parms
 str - source string
 cnt - number of double quotes (0,1)
ew_Quote(str) Escape double quote in string
Parms
 str - source string
ew_Quote2(str) Escape double quote in string (including $ sign)
Parms
 str - source string
SQuote(str) Escape single quote in string
Parms
 str - source string
ew_Dequote(str) Remove enclosing single/double quotes in string
Parms
 str - source string
ew_UnformatName(name) Unformat "=" and "," in name
Parms
 name - name to be unformatted
ew_HtmlValue(str) Return value for proper display in html
Parms
 str - source string
ew_JsEncode(val) Encode value properly for js
Parms
 val - source value
ew_HtmlEncode(str) Encode value properly for html
Parms
 str - source string
ew_PhpValue(str) Encode value properly for PHP
Parms
 str - source string
ew_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
ew_SetDefaultValue(ftype, defvalue) Return default value
Parms
 ftype - ADO Field Type
 defvalue - default value
ew_BoolFieldTagValues(ftype, tagvalues) Return tag values for Boolean field
Parms
 ftype - ADO Field Type
 tagvalues - original tag values
ew_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)
ew_RecPerPageList(sList, iRec) Return record per page list (comma separated)
Parms
 sList - original record per page list
 iRec - default record per page
ew_IsFldFloatFormat(fld) (v9+) Return if field is floating point type
Parms
 fld - field object
ew_IsFldVirtualLookup(fld) (v7.0+) Return if field is a virtual lookup field
Parms
 fld - field object
ew_IsFldForceSelect(fld) (v8.0+) Return if field is force select (auto suggest)
Parms
 fld - field object
ew_VirtualLookupFldSql(fld, idx) (v9+) Return the SQL for the virtual lookup field
Parms
 fld - field object
 idx - language index
ew_VirtualLookupFldName(fld) (v7.0+) Return the field name for the virtual lookup field
Parms
 fld - field object
ew_EscapeRegExChars(str) (v12.0+) Escape the regular expression
Parms
 str - regular expression string
ew_QuotedName(name, dbid) (v12.0+) Return the properly quoted sql name
Parms
 name - table/field name
 dbid - database id
ew_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
ew_FieldSqlName(fld, dbid) (v12.0+) Return the sql name for the field
Parms
 fld - field object
 dbid - database id
ew_CustomViewFieldName(fld, dbid) (v12.0+) Return the field name for the field in the custom view
Parms
 fld - field object
 dbid - database id
ew_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
ew_EncodeName(Name) Encode name in alphabeticnumeric
Parms
 Name - Source name
ew_CodeBaseExist(ScriptType, CodeType, Name) (v2017+) Return if code base exists
Parms
 ScriptType - script type
 CodeType - code type
 Name - script name
ew_CodeBaseItem(ScriptType, CodeType, Name) (v2017+) Return code base item
Parms
 ScriptType - script type
 CodeType - code type
 Name - script name
ew_ScriptExist(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
ew_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
ew_ConvertData(v, t) (v2017+) Get converted data
Parms
 v - original value
 t - value type (Boolean/Integer/Long/Single/Double)
ew_ParseJson(json, reviver) (v2018+) Parse and get JSON object
Parms
 json - the string to parse as JSON
 reviver - reviver function (optional)
ew_GetFieldJsonTypeName(FldTyp) (v2017+) Get field json type name (number/string/boolean)
Parms
 FldTyp - ADO field type
ew_GetFieldTypeName(FldTyp) (v2017+) Get PHPMaker data type name (EW_DATATYPE_*)
Parms
 FldTyp - ADO field type
ew_GetReturnPage(p) (v2017+) Get return page
Parms
 p - page name
ew_LoadField(fldname) (v2017+) Load field object by name
Parms
 fldname - field name
ew_GetFldVal(tbl, fld, fldtype) (v2017+) Get field value expression
Parms
 tbl - table object
 fld - field expression
 fldtype - field type
ew_UseAddOpt() (v2017+) Return if use add option
ew_UseEmailExport() (v2017+) Return if use email export
ew_UseModalLookup() (v2017+) Return if use modal lookup
ew_IsExport() (v2017+) Return if export is enabled
ew_UseTooltip() (v2017+) Return if use tooltip
ew_IsMasterDetail(master, detail) (v2017+) Return if tables have master/detail relationship
Parms
 master - master table name
 detail - detail table name
ew_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
ew_IsRequiredField(f) (v2017+) Return if required field (i.e. NOT NULL)
Parms
 f - field object
ew_IsBoolFld(t, f) Return if Boolean field
Parms
 t - table object
 f - field object
ew_IsValidateText(f) (v2017+) Return if validate as TEXT field
Parms
 f - field object
ew_IsValidateFile(f) (v2017+) Return if validate as file upload field
Parms
 f - field object
ew_IsValidateSearch(f) (v2017+) Return if validate as search field
Parms
 f - field object
ew_IsValidateServer(f) (v2017+) Return if validate on server side
Parms
 f - field object
ew_IsFldEditCtl(f) (v2017+) Return if generate for edit
Parms
 f - field object
ew_IsFldList(f) (v2017+) Return if generate for list
Parms
 f - field object
ew_IsFldReport(f) (v2017+) Return if generate for report
Parms
 f - field object
ew_IsFldBasicSearch(f) (v2017+) Return if generate for basic search
Parms
 f - field object
ew_IsFldExtendedSearch(f) (v2017+) Return if generate for extended search
Parms
 f - field object
ew_IsFldAdvancedSearch(f) (v2017+) Return if generate for advanced search
Parms
 f - field object
ew_IsFldUpdatable(f) (v2017+) Return if field is updatable
Parms
 f - field object
ew_IsFldView(f) (v2017+) Return if generate for view
Parms
 f - field object
ew_IsFldAdd(f) (v2017+) Return if generate for add
Parms
 f - field object
ew_IsFldAddOpt(f) (v2017+) Return if generate for add option
Parms
 f - field object
ew_IsFldEdit(f) (v2017+) Return if generate for edit
Parms
 f - field object
ew_IsFldDelete(f) (v2017+) Return if generate for delete
Parms
 f - field object
ew_IsFldUpdate(f) (v2017+) Return if generate for multiple update
Parms
 f - field object
ew_IsFldRegister(f) (v2017+) Return if generate for register
Parms
 f - field object
ew_IsCustomFld(f) (v2017+) Return if field is a custom field
Parms
 f - field object
ew_ActivateFieldValue(t, f) (v2017+) Get activate field value
Parms
 t - table object
 f - field object
ew_FieldHeaderAttributes(f) (v2017+) Get field header attributes
Parms
 f - field object
ew_SqlTableName(t, dbid) (v2017+) Get SQL for table
Parms
 t - table object
 dbid - database id
ew_BuildCond(cond, opr, newcond) (v2017+) Get PHP condition expression
Parms
 cond - original condition
 opr - and/or (&&/||)
 newcond - new condition
ew_GetProjCssFileName() (v2017+) Get project CSS file name
ew_GetImageFolder() (v2017+) Get image folder name
ew_CharsetToIconvEncoding(Charset) (v2017+) Get Iconv encoding from charset
Parms
 Charset - charset name
ew_CharsetToMySqlCharset(Charset) (v2017+) Get MySQL charset from charset
Parms
 Charset - charset name
ew_IsMsAccess() (v2017+) Return if main database is MS Access
ew_IsMsSQL() (v2017+) Return if main database is Microsoft SQL Server
ew_IsMySQL() (v2017+) Return if main database is MySQL
ew_IsPostgreSQL() (v2017+) Return if main database is PostgreSQL
ew_IsOracle() (v2017+) Return if main database is Oracle
ew_GetOracleServiceName(ConnStr) (v2017+) Get Oracle service name from connection string
Parms
 ConnStr - connection string
ew_UseADOdb() (v2017+) Return if use ADOdb

 

2. System Functions (Overridable)

USAGE: SYS.<FunctionName>

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
ScriptExist(ScriptType, CodeType, ScriptName) (* NOT overridable) Return if script exists
Parms
 ScriptType - script type (Server / Client)
 CodeType - code type (Global / Table / Other)
 ScriptName - script name
ServerScriptExist(CodeType, ScriptName) (* NOT overridable) Return if server script exists
ClientScriptExist(CodeType, ScriptName) (* NOT overridable) Return if client script exists
CustomTemplateExist() (v9+) (* NOT overridable) Return if custom template exists
CustomMultiPageTemplateExist() (v9+) (* NOT overridable) Return if multi-page custom template Exists
CustomListOptions() (v9+) Return custom template list option type (block/blocknotd/single)
CustomTemplateSearchExist() (v9+) (* NOT overridable) Return if list page custom search template exists
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
ScriptTimeout() Return PHP script timeout codes
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() 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)
FieldEditAjaxSelect2(ctlid) (v2017+) Return edit script (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)
FieldEditText2(ctlid) (v2017+) Return edit script (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
IsAggregate() (* NOT overridable) Return if aggregate is enabled
HasFileField() (* NOT overridable) Return if any file fields exist
IsMultiPage() (* NOT overridable) Return if multi-page is enabled
IsAutofillMasterField(ctlid) (* NOT overridable) Return if field is auto fill master field
Parms
 ctlid - control id
IsFileRelatedField(fldname) (* NOT overridable) Return if field is file related field
Parms
 fldname - field name
LookupSql(bDistinct, arFields, sFilter, sRunTimeFilterVar, bAddUserIDFilter, sSelectLimit, bScript) Return codes for lookup SQL
Parms
 bDinstinct - use DISTINCT
 arFields - field array
 sFilter - filter SQL
 sRunTimeFilterVar - run time filter variable
 bAddUserIDFilter - add user id filter
 sSelectLimit - SELECT LIMIT
 bScript - Generate SQL for script
LookupSql1(bDistinct, arFields, sFilter, sRunTimeFilterVar, bAddUserIDFilter, sSelectLimit, bScript) (v12.0+) Return codes for lookup SQL (part 1)
Parms
 bDinstinct - use DISTINCT
 arFields - field array
 sFilter - filter SQL
 sRunTimeFilterVar - run time filter variable
 bAddUserIDFilter - add user id filter
 sSelectLimit - SELECT LIMIT
 bScript - Generate SQL for script
LookupSql2(bDistinct, arFields, sFilter, sRunTimeFilterVar, bAddUserIDFilter, sSelectLimit, bScript) (v12.0+) Return codes for lookup SQL (part 2)
Parms
 bDinstinct - use DISTINCT
 arFields - field array
 sFilter - filter SQL
 sRunTimeFilterVar - run time filter variable
 bAddUserIDFilter - add user id filter
 sSelectLimit - SELECT LIMIT
 bScript - Generate SQL for script
SelectionList(ctlid) Return selection list in JSON
Parms
 ctlid - control id
ConnectionString(db) (v12.0+) Return database connection string
Parms
 db - database object
DatabaseConnection(db) (v12.0+) Return database connection array
Parms
 db - database object

 

 ©2002-2017 e.World Technology Ltd. All rights reserved.