System Functions

 

I. Common utility functions
Function Name Description
GetRid() (v2018+) Get ASP.NET Core runtime identifier
Throw(message) (v2017+) Throw an error message
Parms
 message - error message
GetJavaScripts() (v2018+) Get the list of JavaScript used as array
GetStyleSheets() (v2018+) 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) (v13) Return database id for table name
Parms
 tablename - table name
DbType(dbid) (v13) Return database type for database id
Parms
 dbid - database id
MultiPageFldAttr(f) (v13) 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() (v12+) Return if user table is specified
IsEmpty(val) (v10+) Return if value is empty
Parms
 val - value
FormObj(ctlid) (v10+) Return form object name
Parms
 ctlid - control id
GetLanguageFieldProperty(lang, tbl, fld, propname) (v10+) Return field property for multi-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) (v11+) Remove Alias from field (i.e. <FIELD> AS <ALIAS> => <FIELD>)
Parms
 fld - sql field
SelectFields(ar, idx, sep) (v10+) Return SELECT field list from language field array
Parms
 ar - field array
 idx - language index
 sep - field separator
SqlSelect(sSelectLimit, sDistinct, sSelect, sFrom) (v10+) Return SQL SELECT statement
Parms
 sSelectLimit - SELECT LIMIT part
 sDistinct - use SELECT DISTINCT
 sSelect - SELECT part
 sFrom - FROM part
CustomScriptRowCnt() (v10+) Return custom template script id
CustomScriptRowStartVar() (v10+) Return custom template row start variable
CustomScriptRowVar() (v10+) Return custom template row variable
CustomScriptVar() (v10+) Return custom template control variable
CustomScriptId(name, type ,idx) (v10+) Return custom template script id
Parms
 name - script name
 type - script type
 idx - row index (list/delete page)
CustomScripTag(name, type, idx) (v10+) Return custom template script tag
Parms
 name - script name
 type - script type
 idx - row index (list/delete page)
GetJsScript(html) (v10+) Return JavaScript from HTML
Parms
 html - source HTML
RemoveJsScript(html) (v10+) Remove JavaScript from HTML
Parms
 html - source HTML
CastFieldForLike(tbl, fld, type, dateformat) (v10+) 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
SameText(Str1, Str2) Return if both string match (case insensitive)
Parms
 Str1 - string 1
 Str2 - string 2
HasTagValue(fld, val) Return if field contains tag value
Parms
 fld - field object
 val - tag value
FldTagValue(fld) Return field tag values
Parms
 fld - field object
SplitTagValue(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) (v13.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) (v13.0+) Return parent select field
Parms
 f - field object
 i - index (1-4)
GetParentSelectTbl(f, i) (v13.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) (v8.0+) Return row object name (using lRowCnt)
Parms
 v - object name
RowVarQuoted(v) Return row object name (usinjg lRowIndex with quote)
Parms
 v - object name
RowVar(v) Return row object name (using lRowIndex)
Parms
 v - object name
RowVarToQuoted(v) Return row object name (with quote and remove @)
Parms
 v - object name
Val(v) (v8.0+) Return ASP.NET boolean
Parms
 v - value
JsVal(v) (v8.0+) Return javascript boolean ("true"/"false")
Parms
 v - value
SecurityCheck(sId, bSecurity, bUserlevel) Return Security Checking codes
Parms
 sId - control id
 bSecurity - security is enabled
 bUserLevel - user level is enabled
RandomIntInclusive(min, max) (v2018+) Returns a random integer between min (included) and max (included)
Parms
 min - minimum inclusive
 max - maximum inclusive
RandomKey() Return random key
FolderPath(id) Return folder path based on control id
Parms
 id - control id
PageObj() Return page object
TableObj(tblvar) (v2018+) Return table object name
Parms
 tblvar - table var
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 wwwroot
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 with two double quotes
Parms
 str - source string
Dequote(str) Replace embracing double quote or single quote
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)
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) (v10+) Return if field is floating point type
IsFldVirtualLookup(fld) (v8.0+) Return if field is a virtual lookup field
Parms
 fld - field object
IsFldForceSelect(fld) Return if field is an autosuggest with force selecte enabled
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) (v13.0+) Escape the regular expression
Parms
 str - regular expression string
QuotedName(name, dbid) (v13.0+) Return the properly quoted sql name
Parms
 name - table/field name
 dbid - database id
SqlConcatName(tbl, name1, name2, fld, idx) (v13.0+) 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) (v13.0+) Return the sql name for the field
Parms
 fld - field object
 dbid - database id
CustomViewFieldName(fld, dbid) (v13+) Return the field name for the field in the custom view
Parms
 fld - field object
 dbid - database id
VirtualTableInCustomView(CustomSQL, TblName, dbid) (v13+) 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, Language) (v2017+) Return if code base exists
Parms
 ScriptType - script type
 CodeType - code type
 Name - script name
 Language - language
CodeBaseItem(ScriptType, CodeType, Name, Language) (v2017+) Return code base item
Parms
 ScriptType - script type
 CodeType - code type
 Name - script name
 Language - language
CustomScriptExist(ScriptType, CodeType, Name, Lang, CtrlID, L1Key, L2Key) (v2017+) Return if custom script exists
Parms
 ScriptType - script type
 CodeType - code type
 Name - script name
 Lang - language
 CtrlID - control id
 L1Key - table key
 L2Key - field key
ScriptItem(ScriptType, CodeType, Name, Lang, CtrlID, L1Key, L2Key) (v2017+) Return custom script item
Parms
 ScriptType - script type
 CodeType - code type
 Name - script name
 Lang - language
 CtrlID - control id
 L1Key - table key
 L2Key - field key
GetServerEvent(CodeType, ScriptName, ControlID, Modifier) Return server event codes
Parms
 CodeType - code type
 ScriptName - script name
 ControlID - control id
 Modifier - modifier name
GetVirtualEvent(CodeType, ScriptName) Return virtual server event codes
Parms
 CodeType - code type
 ScriptName - script name
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 ASP.NET Maker data type name (Config.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
IsBlobView(f) Return if field is a binary upload 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 C# 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
GetClassName(ctrlid) Get class name for control id
Parms
 ctrlid - control id
CheckUploadPath(path) Check upload path
Parms
 path - upload path
GenChangePwd() Check if generate change password page
CharsetToMySqlCharset(Charset) Convert charset to MySQL charset
Parms
 Charset - charset
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
IsODBC() Return if main database is ODBC
UseTagHelpers() Check if use Tag Helpers
UseLdap() Check if use Ldap
GetConnClass(dbid) Get connection class from dbid
Parms
 dbid - database id
GetDbType(dbid) Get database type from dbid
Parms
 dbid - database id
AddProvider(dbid) Add database provider to namespace
Parms
 dbid - database id
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, CtrlID) Return if server script exists
ServerScriptExist2(CodeType, ScriptName, CtrlID) (* NOT overridable) Return if Server Script Exists (for override)
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

 

II. Overridable Functions

Function Name Description
CharSet() Return <meta> tag for charset specified
FavIcon() (v8.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) (v10+) 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() (v10+) Return custom template list option type (block/blocknotd/single)
GetCustomTemplate() (v10+) Return translated custom template
GetCustomTemplatePage(pageid) (v10+) Return translated custom template for page (multi-page layout)
Parms
 pageid - page id (1/2/3/...)
ParseTemplate(template,id) (v10+) 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() (v10+) Return translated list page custom search template
RenderCustomTemplate() (v10+) Return rendering codes for list page custom search template
RenderCustomTemplateSearch() (v10+) Return rendering codes for list page custom search template
GetCustomViewTemplate(fld, src) (v10+) 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 ASP.NET Include file statement
Parms
 fn - file control id
 parm - extra parameter
DatabaseConnection(db) (v13.0+) Return database connection array
Parms
 db - database object
Security() Return ASP.NET Security checking codes
ScriptInsert() Return ASP.NET codes for inserting a record
ScriptUpdate() Return ASP.NET codes for updating a record
Script(ctlid) Return ASP.NET codes for inserting/updating a record
Parms
 ctlid - "insert" / "update"
ScriptUpdateFile() Return ASP.NET codes for file upload to folder
ScriptUpdateFileData(ctlid)
Parms
 ctlid - "insert" / "update"
Return ASP.NET codes to prepare data for file upload to folder
ScriptUpdateSpecial() Return ASP.NET codes for updating detail key field
ScriptCommon() Return ASP.NET codes for rendering field (common)
ScriptViewRefer() Return ASP.NET codes for rendering field for VIEW (HREF)
ScriptAddRefer() Return ASP.NET codes for rendering field for ADD (HREF)
ScriptEditRefer() Return ASP.NET codes for rendering field for EDIT (HREF)
ScriptReferCall(cv, vv, ctlid) Return ASP.NET codes for rendering field for HREF
Parms
 cv - current value
 vv - view value
 ctlid - control id
ScriptView() Return ASP.NET codes for rendering field for VIEW
ScriptViewCall(cv, vv) Return ASP.NET codes for rendering field for VIEW
Parms
 cv - Current Value
 vv - View Value
ScriptViewNo(cv, vv) Return ASP.NET codes for rendering field for VIEW (AutoNumber field)
ScriptViewText(cv, vv) Return ASP.NET codes for rendering field for VIEW (TEXT field)
ScriptViewHighlightSearch(cv, vv) Return ASP.NET codes for rendering field for search highlight
ScriptViewFormat(fld, parm) (v10+) Return ASP.NET codes for field View Tag format
Parms
 fld - field object
 parm - Field to be formatted
ScriptViewPassword(cv, vv) Return ASP.NET codes for rendering field for VIEW (PASSWORD field)
ScriptViewRadio(cv, vv) Return ASP.NET codes for rendering field for VIEW (RADIO field)
ScriptViewTable(cv, vv) Return ASP.NET codes for rendering field for VIEW (Link to Table field)
ScriptViewValues(cv, vv) Return ASP.NET codes for rendering field for VIEW (Lookup Value field)
ScriptViewCheckbox(cv, vv) Return ASP.NET codes for rendering field for VIEW (CHECKBOX field)
ScriptViewSelect(cv, vv) Return ASP.NET codes for rendering field for VIEW (SELECT field)
ScriptViewTextarea(cv, vv) Return ASP.NET codes for rendering field for VIEW (TEXTAREA field)
ScriptViewHidden(cv, vv) Return ASP.NET codes for rendering field for VIEW (HIDDEN field)
ScriptViewFile(cv, vv) Return ASP.NET codes for rendering field for VIEW (FILE field)
ScriptViewHref(cv, vv) Return ASP.NET codes for rendering field for VIEW (HREF field)
ScriptViewVirtual(wrk, vv) Return ASP.NET codes for rendering virtual lookup field
Parms
 wrk - original rendering codes
 vv - view value
ScriptAdd() Return ASP.NET codes for rendering field for ADD
ScriptEdit() Return ASP.NET codes for rendering field for EDIT
ScriptEditCall(cv, ev, ctlid) Return ASP.NET codes for rendering field for ADD/EDIT/SEARCH
Parms
 cv - Current Value
 ev - Edit Value
 ctlid - Control ID
ScriptEditFormat(ctl) (v10+) Return ASP.NET codes to format field for EDIT
Parms
 ctl - control
ScriptSearch() Return ASP.NET codes for rendering field for SEARCH (Search Field 1)
ScriptSearch2() Return ASP.NET codes for rendering field for SEARCH (Search Field 2)
ScriptEditDefaultValue() Return ASP.NET codes for rendering field for Default Value
ScriptEditNo(cv, ev, ctlid) Return ASP.NET codes for rendering field for EDIT (AutoNumber field)
ScriptEditText(cv, ev, ctlid) Return ASP.NET codes for rendering field for EDIT (TEXT field)
ScriptEditPassword(cv, ev, ctlid) Return ASP.NET codes for rendering field for EDIT (PASSWORD field)
ScriptEditRadio(cv, ev, ctlid) Return ASP.NET codes for rendering field for EDIT (RADIO field)
ScriptEditTable(cv, ev, ctlid) Return ASP.NET codes for rendering field for EDIT (Link to Table field)
ScriptEditUserID(cv, ev, ctlid) Return ASP.NET codes for rendering field for EDIT (User ID field)
ScriptEditValues(cv, ev, ctlid) Return ASP.NET codes for rendering field for EDIT (Lookup Value field)
ScriptEditCheckbox(cv, ev, ctlid) Return ASP.NET codes for rendering field for EDIT (CHECKBOX field)
ScriptEditSelect(cv, ev, ctlid) Return ASP.NET codes for rendering field for EDIT (SELECT field)
ScriptEditTextarea(cv, ev, ctlid) Return ASP.NET codes for rendering field for EDIT (TEXTAREA field)
ScriptEditHidden(cv, ev, ctlid) Return ASP.NET codes for rendering field for EDIT (HIDDEN field)
ScriptEditFile(cv, ev, ctlid) Return ASP.NET codes for rendering field for EDIT (FILE field)
ScriptAggregate() Return ASP.NET 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) 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)
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)
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
AspReqValidator() Return ASP.NET validator for required field
AspReqErrMsg() Return ASP error message for required field
AspReqDefaultMsg() Return default ASP error message for required field
AspSearchValidator() Return ASP.NET validator for search field
AspValidator() Return ASP.NET validator
AspFileValidator() Return ASP.NET validator for file type
AspValidatorCommon(fld, msg) Return ASP.NET validator
Parms
 fld - field
 msg - message
AspErrMsg() Return ASP.NET error message
AspDefaultMsg() Return default ASP error message
DbDataType(dbid) Return ASP.NET Core data type name for current field
Parms
 dbid - database id
OdbcDataType(lFldType,sFldTypeName) Return ASP.NET Core ODBC data type for current field
Parms
 lFldType - current field type
 sFldTypeName - current field type name
OracleDataType(lFldType,sFldTypeName) Return ASP.NET Core Oracle data type for current field
Parms
 lFldType - current field type
 sFldTypeName - current field type name
SqlDataType(lFldType,sFldTypeName) Return ASP.NET Core MSSQL data type for current field
Parms
 lFldType - current field type
 sFldTypeName - current field type name
MySqlDataType(lFldType,sFldTypeName) Return ASP.NET Core MySQL data type for current field
Parms
 lFldType - current field type
 sFldTypeName - current field type name
PostgreSqlDataType(lFldType,sFldTypeName) Return ASP.NET Core PostgreSQL data type for current field
Parms
 lFldType - current field type
 sFldTypeName - current field type name
LookupSettings(lang) (v2019+) Return lookup settings
Parms
 lang - language id

 

 ©2004-2019 e.World Technology Ltd. All rights reserved.