1. System Functions (Common utility functions)

Function Name Description
ew_ContainText(Str, Find) Return True if "Find" in "Str" (Boolean)
Parms
 Str (String) - Source string
 Find (String) - Find string
ew_SplitTagValues(str) Return an array of tag values
Parms
 str (String) - "value 1","value 2",...
ew_IsBinaryField(FIELD) Return True if field is binary (Boolean)
Parms
 FIELD (Object) - Field object
ew_SummaryValueName(id) Return summary value name (String)
- (SumValue / AvgValue / MinValue / MaxValue)
Parms
 id (String) - Sum/Avg/Min/Max
ew_SummaryViewValueName(id) Return summary view value name (String)
- (SumViewValue / AvgViewValue / MinViewValue / MaxViewValue)
Parms
 id (String) - Sum/Avg/Min/Max
ew_PageObj() Return page object name (String)
ew_CssInherit(parm) Return "inherit" if parm is empty (String)
ew_FieldName() Return field SQL name from FIELD object (String)
ew_FieldSqlName(f) Return field SQL name (String)
Parms
 f (Object) - Field object
ew_TableName(t) Return table SQL name (String)
Parms
 t (Object) - Table object
ew_QuotedName(obj) Return SQL quoted name (String)
Parms
 obj (String) - Object name
ew_FolderPath(id) Return folder path (String)
Parms
 id (String) - Control id
ew_GetFileNameByCtrlID(id) Return file name based on control id (String)
Parms
 id (String) - Control id
ew_EscapeString(sSrc, sEsc) Return escaped string (String)
Parms
 sSrc (String) - Source string
 sEsc (String) - Escape string
 (double quote for VB, backslash for C#)
ew_DoubleQuote(str, cnt) Return double quoted string (String)
Parms
 str (String) - Source string
 cnt (String) - quote count
ew_IsBoolFld() Return True if boolean field (Boolean)
ew_GetFieldType(fType) Return Field Type based on ADO Field Type
Parms
 fType (Long) - ADO Field Type
Return Values
 1 - Numeric Type
 2 - Date/Time Type
 3 - String Type
 4 - Boolean Type
 5 - GUID Type
 6 - Other Type
ew_IsDbGrpFld(grptype) Return True if database group type (Boolean)
Parms
 grptype (String) - "f", "i", "y", "q", "m", "w", "d", "h", "min"
ew_DbGrpSql(grptype, grpint) Return grouping SQL (String)
Parms
 grptype (String) - "f", "i", "y", "q", "m", "w", "d", "h", "min"
 grpint (Long) - grouping interval ("f" / "i" types only)
ew_Val(v) Return "TRUE" / "FALSE" for boolean value (String)
Parms
 v (Boolean) - Boolean value
ew_ZeroPad(m, t) Return zero padded string (String)
Parms
 m (String) - Source string
 t (Long) - Field length
ew_BoolToStr(b) Return "TRUE"/"FALSE" from boolean (String)
Parms
 b (Boolean)
ew_RandomKey() Return a random key string (String)
ew_Quote(str) Escape double quote in string (String)
Parms
 str (String) - Source string
ew_SQuote(str) Escape single quote in string (String)
Parms
 str (String) - Source string
ew_UnQuote(str) Remove single/double quotes in string (String)
Parms
 str (String) - Source string
ew_RecPerPageList(sList, iRec) Return formatted comma-delimited Record Per Page List
Parms
 sList (String) - User Specified Record Per Page List
 iRec (Integer) - User Specified Records Per Page
ew_SQLPart(sSQL, sId) Return different sections of SQL (String)
Parms
 sSQL (String) - SELECT SQL
 sId (String) - Identifier for different sections of SQL
(SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, LIMIT)
ew_ChartCount(Pos) Return number of charts in position (String)
Parms
 Pos (Long) - 1 (Top), 2 (Left), 3 (Right), 4 (Bottom)

2. System Functions (Overridable)

USAGE: SYSTEMFUNCTIONS.<FunctionName>

Function Name Description
Charset() Return meta tag string for Charset specified (String)
CssFile() Return href string for Css File specified (String)
FavIcon() Return href string for Fav Icon (String)
HeaderLogo() Return header logo (String)
GetScript(scripttype,codetype,scriptname) Return Server Event / Client Script codes (String)
Parms
 scripttype (String) - script type ("Server"/"Client")
 codetype (String) - code type ("Global"/"Table"/"Other")
 scriptname (String) - script name
GetServerScript(codetype,scriptname) Return Server Event codes (String)
Parms
 codetype (String) - code type ("Global"/"Table"/"Other")
 scriptname (String) - script name
GetClientScript(codetype,scriptname) Return Client Script codes (String)
Parms
 codetype (String) - code type ("Global"/"Table"/"Other")
 scriptname (String) - script name
ScriptExist(scripttype,codetype,scriptname) Return if Server Event / Client Script codes exists (Boolean)
Parms
 scripttype (String) - script type ("Server"/"Client")
 codetype (String) - code type ("Global"/"Table"/"Other")
 scriptname (String) - script name
ServerScriptExist(codetype,scriptname) Return if Server Event codes exists (Boolean)
Parms
 codetype (String) - code type ("Global"/"Table"/"Other")
 scriptname (String) - script name
ClientScriptExist(codetype,scriptname) Return if Client Script codes exists (Boolean)
Parms
 codetype (String) - code type ("Global"/"Table"/"Other")
 scriptname (String) - script name
PHPCgiPath() Return CGI path (String)
NoCache() Return PHP No Cach codes (String)
IncludeFile(id,parm) Return PHP include codes (String)
Parms
 id (String) - Control id
 parm (String) - "compat" to generate compat header/footer
ConnectionString() Return database connection string (String)
Security() Return security checking codes (String)
ScriptSummaryViewRefer() Return PHP codes for rendering summary field for VIEW (HREF) (String)
ScriptViewRefer() Return PHP codes for rendering field for VIEW (HREF) (String)
ScriptGroupView() Return PHP codes for rendering grouping field for VIEW (String)
ScriptGroupSummaryView() Return PHP codes for rendering grouping field for VIEW (Summary) (String)
ScriptView() Return PHP codes for rendering field for VIEW (String)
ScriptSummaryView(id) Return PHP codes for rendering field for VIEW (Summary) (String)
Parms
 id (String) - Sum/Avg/Min/Max
ScriptViewCall(cv, vv, dtl) Return PHP codes for rendering field for VIEW (String)
Parms
 cv (String) - Current Value
 vv (String) - View Value
 dtl (Boolean) - detail field
ScriptViewNo(cv, vv) Return PHP codes for rendering field for VIEW (AutoNumber field) (String)
ScriptViewText(cv, vv) Return PHP codes for rendering field for VIEW (TEXT field) (String)
ScriptViewFormat(parm) Return PHP codes for field View Tag format (String)
Parms
 parm - Field to be formatted
ScriptViewPassword(cv, vv) Return PHP codes for rendering field for VIEW (PASSWORD field) (String)
ScriptViewRadio(cv, vv) Return PHP codes for rendering field for VIEW (RADIO field) (String)
ScriptViewTable(cv, vv) Return PHP codes for rendering field for VIEW (Link to Table field) (String)
ScriptViewValues(cv, vv) Return PHP codes for rendering field for VIEW (Lookup Value field) (String)
ScriptViewCheckbox(cv, vv) Return PHP codes for rendering field for VIEW (CHECKBOX field) (String)
ScriptViewSelect(cv, vv) Return PHP codes for rendering field for VIEW (SELECT field) (String)
ScriptViewTextarea(cv, vv) Return PHP codes for rendering field for VIEW (TEXTAREA field) (String)
ScriptViewHidden(cv, vv) Return PHP codes for rendering field for VIEW (HIDDEN field) (String)
ScriptViewFile(cv, vv) Return PHP codes for rendering field for VIEW (FILE field) (String)
ScriptViewHref(cv, vv) Return PHP codes for rendering field for VIEW (HREF field) (String)
FieldSummaryGroupView() Return field control for Summary Group VIEW (String)
FieldGroupView() Return field control for Group VIEW (String)
FieldSummaryView() Return field control for Summary VIEW (String)
FieldView() Return field control for VIEW (String)
FieldViewCall(cv, vv) Return field control for VIEW (String)
FieldViewCheckbox(cv, vv) Return field control for VIEW (CHECKBOX field) (String)
FieldViewPassword(cv, vv) Return field control for VIEW (PASSWORD field) (String)
FieldViewText(cv, vv) Return field control for VIEW (TEXT field) (String)
FieldViewFile(cv, vv) Return field control for VIEW (FILE field) (String)
FieldViewHref(ctl, vv) Return field control for VIEW (HREF field) (String)
Parms
 ctl (String) - Control to be HREF
FieldSearch() Return extended filter textbox 1 (String)
FieldSearch2() Return extended filter textbox 2 (String)
FieldEditText(ctl, val) Return field control for EDIT (TEXT field) (String)
Parms
 ctl (String) - Control
 val (String) - Value
FieldEditPopupCalendar(ctl) Return field control for popup calendar (String)
Parms
 ctl (String) - Control field
FieldOperator() Return extended filter field operator 1 (String)
FieldOperator2() Return extended filter field operator 2 (String)
FieldOperatorCall(ctl, val, opr) Return extended filter field operator based on parameter (String)
Parms
 ctl (String) - Control
 val (String) - Value
 opr (String) - Operator
FieldSearchCondition() Return extended filter condition (String)
GroupByFieldNames() Return group by field names (comma separated) (String)
OrderByFieldNames() Return order by field names (comma separated) (String)
UpdateSearchJs() Return js to update search operators (String)
JsValidator() Return Validator JS for extended filter (String)
JsValidatorCall(ctl) Return Validator JS for extended filter based on parameter (String)
Parms
 ctl (String) - Control
JsErrMsg() Return JS error message for extended filter (String)
JsDefaultMsg() Return JS default error message for extended filter (String)
PhpValidator() Return PHP (Server Side) validator for extended filter (String)
PhpValidatorCommon(fld, msg) Return PHP (Server Side) validator for extended filter based on parameters (String)
Parms
 fld (String) - field name
 msg (String) - error message
PhpDefaultMsg() Return PHP (Server Side) default error message for extended filter (String)
IsExport() Return if export is enabled (Boolean)
RowFieldNames() Return row field names for crosstab reports (comma separated) (String)
ColumnFieldNames() Return crosstab column field name (String)
SummaryFieldNames() Return crosstab summary field name (String)
CrosstabSql(sqlpart) Return Crosstab SQL in Parts (String)
Parms
 sqlpart (String) - SQL Part
SELECT, FROM, WHERE, GROUP BY, ORDER BY, SELECT AGGREGATE, GROUP BY AGGREGATE
CrosstabYearSql() Return Crosstab SQL to get distinct year values (String)
DistinctColumnSql(sqlpart) Return Crosstab SQL to get distinct column values (String)
Parms
 sqlpart (String) - SQL Part
SELECT
ReportSql(sqlpart) Return Summary/List SQL in Parts (String)
Parms
 sqlpart (String) - SQL Part
SELECT, FROM, WHERE, GROUP BY, HAVING, ORDER BY, SELECT AGGREGATE, AGGREGATE PREFIX

 
 ©2007-2011 e.World Technology Ltd. All rights reserved.