System Functions

1. System Functions (Common utility functions)

USAGE: SYSTEMFUNCTIONS.<FunctionName>

Function Name	Description
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 lRowCnt) 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_PageObj	Return page object
ew_BtnCaption(name)	Return button caption name Parms name - original caption name
ew_SecurityCheck(sId, bSecurity, bAnonymous, bUserlevel)	Return Security Checking codes Parms sId - control id bSecurity - security is enabled sAnonymous - page is anonymous 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_JsVal(v) (v7.0+)	Return javascript boolean ("true"/"false") Parms v - value
ew_Val(v) (v7.0+)	Return PHP boolean value ("TRUE"/"FALSE") Parms v - value
ew_RandomKey	Return random key
ew_FieldName	Return sql field name
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_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 with two double quotes Parms str - source string
ew_Dequote(str)	Replace embracing double quote or single quote 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)
ew_RecPerPageList(sList, iRec)	Return record per page list (comma separated) Parms sList - original record per page list iRec - default record per page
ew_IsFldVirtualLookup(fld) (v7.0+)	Return if field is a virtual lookup field Parms fld - field object
ew_VirtualLookupFldSql(fld) (v7.0+)	Return the SQL for the virtual lookup field Parms fld - field object
ew_VirtualLookupFldName(fld) (v7.0+)	Return the field name for the virtual lookup field Parms fld - field object
ew_QuotedName(name) (v7.0+)	Return the properly quoted sql name Parms name - table/field name
ew_SqlConcatName(name1, name2) (v7.0+)	Return the concat sql name Parms name1 - field name 1 name2 - field name 2
ew_FieldSqlName(fld) (v7.0+)	Return the sql name for the field Parms fld - field object

2. System Functions (Overridable)

USAGE: SYSTEMFUNCTIONS.<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
GetServerScript(CodeType, ScriptName)	Return Server Scripts
GetClientScript(CodeType, ScriptName)	Return Client Scripts
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
ScriptTimeout	Return PHP script timeout codes
PHPDirective	Return PHP Directives
SessionTimeout	Return PHP Session Timeout codes
NoCache	Return PHP No Cache codes
IncludeFile(fn, parm)	Return PHP Include file statement Parms fn - file control id parm - extra parameter
ConnectionString	Return Database Connection String
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 for file upload to folder
ScriptUpdateDetailKey	Return PHP codes for updating detail key field
ScriptCommon	Return PHP codes for rendering field (common)
ScriptViewRefer	Return PHP codes for rendering field for VIEW (HREF)
ScriptEditRefer	Return PHP codes for rendering field for EDIT (HREF)
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(parm)	Return PHP codes for field View Tag format Parms 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)	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)	Return PHP codes for rendering field for VIEW (HREF field)
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
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)	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
FieldList	Return field control for LIST
FieldAggregate	Return field control for AGGREGATE
FieldView	Return field control for VIEW
FieldViewCall(cv, vv)	Return field control for VIEW Parms cv - Current Value vv - View Value
FieldViewCheckbox(cv, vv)	Return field control for VIEW (CHECKBOX field)
FieldViewFile(cv, vv)	Return field control for VIEW (FILE field)
FieldViewFileConfirm(cv, vv)	Return field control for VIEW (FILE field confirm page)
FieldViewText(cv, vv)	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)
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)
GroupByFieldCount	Return Group By Field count
GroupByFields	Return Group By Field (comma separated)
GroupByFieldNames	Return Group By Field names (comma separated)
GroupByFieldSources	Return Group By Field sources (comma separated)
OrderByFieldCount	Return Order By Field count
OrderByFields	Return Order By Field (comma separated)
OrderByFieldNames	Return Order By Field names (comma separated)
OrderByFieldSources	Return Order By Field sources (comma separated)
UpdateComboJS(ctlid)	Return js to update dynamic selection list Parms ctlid - Control ID
UpdateSearchJS	Return js to update dynamic selection list (search)
JsReqValidator	Return js validator for required field
JsReqErrMsg	Return js error message for required field
JsReqDefaultMsg	Return default js error message for required field
JsValidator	Return js validator
JsFileTypeValidator	Return js validator for file type
JsErrMsg	Return js error message
JsDefaultMsg	Return default js error message
PhpReqValidator	Return PHP validator 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
IsAggregate	Return if Aggregate is enabled
HasFileField	Return if Has File Field
IsExport	Return if Export enabled
IsMultiPage	Return if MultiPage is enabled
HasAutoSuggest	Return if Has Auto Suggest Field
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