Object Properties

Please refer to the following table for detailed description of Objects and their properties for use with Template Tags.

 

I. Objects

Project Description
CTRL Control Object
PROJ Project Object
PROJ.MasterDetails Master Details Object
PROJ.CustomScripts Custom Scripts Object
PROJ.Menus Menus Object
DB Database Object
TABLE Table Object
FIELD Field Object
PROJ.LINKDBS (v12.0+) Link Databases Object
Note You can view the object properties by opening your Project File with a text editor. Project file is an XML file, each object is represented by an XML node in the project file. The object properties are saved as attributes of the node. The property name is same as the attribute name.

II. Properties

You can use the standard dot notation to access properties of the objects.

Example

<!--##=PROJ.ProjName##-->

This line will write the project name in the output file.

 

CTRL Object

The CTRL Object points to the current control in control.xml that is being generated.

Property Description Data Type
CtrlID Control id (e.g. list, view, edit, etc.) String
CtrlType Control type (e.g. table, report, field, other, copy, etc.) String

 

PROJ Object

The PROJ Object points to the current project. You can access the current project properties by PROJ.PropertyName.

Property Description Data Type
ProjID (v9+) Project ID (GUID) String
ProjName Project name String
ProjVar Project variable String
MultiLanguage Use multiple languages Boolean
DefaultLanguageFile Default language file String
LanguageFiles Language file list (comma separated) String
AppCompatVersion Compat version Integer
AppRelatedProject Related project file String
SQLQuote SQL quote identifier (Square Bracket / Double Quote / Single Quote / Back Quote / None / Default) String
CodePage Code page Integer
Cache Allow cache Boolean
CharSet Character set String
CSS External CSS file String
OutputNameType Output file name option:
"" - No prefix or suffix
"Prefix" - Prefix with extension
"Suffix" - Suffix with extension		 String
OutputNameExt Output file name extension name String
OutputNameLCase Output file name in lowercase Boolean
BodyTitle Body title description String
BodyFont Body font String
BodySize Body size String
BodyBgColor Body background color (deprecated) String
BodyTextColor Body text color (deprecated) String
BodyLnkColor Body link color (deprecated) String
BodyVLnkColor Body vlink color (deprecated) String
BodyALnkColor Body alink color (deprecated) String
BodyLeftMargin Body left margin (deprecated) Integer
BodyTopMargin Body top margin (deprecated) Integer
DocType (v6.0+) Document Type String
ApplicationTheme (v6.0+) Application Theme String
HeaderColor (v5.0+) Page header color (deprecated) String
HeaderLogo (v5.0+) Page header logo file name String
HeaderHeight (v5.0+) Page header height (deprecated) Integer
MenuColor (v5.0+) Page menu color (deprecated) String
FooterColor (v5.0+) Page footer color (deprecated) String
FooterFontColor (v5.0+) Page footer font color (deprecated) String
FooterText (v5.0+) Page footer text String
TblWidth Table width (deprecated) String
TblPadding Table padding (deprecated) Integer
TblBorder Table border (deprecated) Integer
TblSpacing Table spacing (deprecated) Integer
TblBgColor Table background color (deprecated) String
TblHdrFontColor Table header font color (deprecated) String
TblHdrColor Table header background color (deprecated) String
TblAltColor Table use alternate row color (deprecated) Boolean
TblAltColor1 Table alternate color 1 (deprecated) String
TblAltColor2 Table alternate color 2 (deprecated) String
Template Template file location String
Destination Output destination folder location String
SecType Security type:
"None" - no security
"Hard Code" - use hard coded administrator login / password
"Use Table" - use security table
"Both" - Use both security table & hard coded administrator login / password		 String
SecLoginID Administrator login id String
SecPasswd Administrator password String
SecTbl Security table name String
SecLoginIDFld Security table login id field name String
SecPasswdFld Security table password field name String
SecEmailFld Security table email field name String
SecForgetPwdPage Generate forget password page Boolean
SecChangePwdPage Generate change password page Boolean
SecChangeEmail Send email for password change Boolean
SecRegisterPage Generate registration page Boolean
RegisterReturnPage (v6.0+) Registration return page String
RegisterMultiPage (v6.0+) Register page use multi page layout Boolean
SecRegisterConfirm (v5.0+) Registration page needs confirm Boolean
SecRegisterCaptcha (v5.0+) Registration page uses captcha Boolean
SecLogInOutAuditTrail (v5.0+) Login / logout page needs audit trail Boolean
SecLoginCaptcha (v9+) Login page uses captcha Boolean
SecForgotPwdCaptcha (v9+) Forgot password page uses captcha Boolean
SecChangePwdCaptcha (v9+) Change password page uses captcha Boolean
SecRegisterActivate (v5.0+) Registration page needs activation Boolean
SecRegisterActivateFld (v5.0+) Registration page activation field name String
SecRegisterEmail Send email for registration Boolean
SecRegisterAutoLogin Auto login for registration Boolean
SecSenderEmail Sender email address String
SmtpServer SMTP server name String
SmtpServerPort SMTP server port Long
SmtpSecureOption (v9+) SMTP secure option (SSL/TLS) String
MemoCRLFReplace Replace CRLF with BR for memo field Boolean
TestWebServer Testing web server:
1 - PHP
2 - Other		 Integer
DefaultDateFormat Default date format (deprecated)
Integer
DateSeparator Date separator: "/", "-", "." (deprecated) String
SetLocale Set locale (deprecated) Boolean
Locale Locale id (e.g. en_US) (deprecated) String
CGI Use CGI (deprecated) Boolean
CGIPath CGI Path (deprecated) String
Ext Extension (deprecated) String
DefaultPage Default page name (deprecated) String
StartPage (v9+) Project start page String
XMLEncoding XML encoding charset String
HighlightColor List page row highlight color (deprecated) String
SelectColor List page row select color (deprecated) String
EditBackColor List page edit row background color (deprecated) String
EditForeColor List page edit row color (deprecated) String
PagerBackColor Pager background color (deprecated) String
FooterBackColor Footer (aggregated values) background color (deprecated) String
UploadPath File upload path String
UploadAllowedFileExt Allowed upload file extensions String
UseCss Use CSS (deprecated) Boolean
CssStyles User css style content String
AutoSync Auto synchronize when open project Boolean
AutoBrowseURL (v9+) Auto browse URL String
AutoBrowse Auto browse after generation Boolean
OtherGenList (v7.0+) Generation list for other scripts. Format:
@db=1|@css=0|... (Generate "db" = Yes, Generate "css" = No, ...)		 String
OtherGen Generate other scripts Boolean
OtherExpanded (v7.0+) Expand the other generation list (for display) Boolean
DynamicLoadDB Load database dynamically Boolean
MD5Password (v6.0+) Use hased password Boolean
CaseSensitivePassword (v6.0+) Use Case Sensitive password Boolean
ServerValidate (v6.0+) Use server validation Boolean
ClientValidate (v6.0+) Use client validation Boolean
RptIndent Report header indentation in pixels (deprecated) Integer
RecPerPage Records per page Integer
RecPerPageList Comma separated values for records per page (list page only) String
PrinterFriendly (v6.0+) Printer Friendly Boolean
ExportHtml Export to HTML Boolean
ExportWord Export to Word Boolean
ExportExcel Export to Excel Boolean
ExportXml Export to XML Boolean
ExportCSV Export to CSV Boolean
ExportEmail (v7.0+) Export to email Boolean
ExportPDF (v8.0+) Export to PDF Boolean
ExportType (v7.0+) Export Type:
"SELECTED" = export selected records
"PAGE" = export current page
"ALL" = export all records		 String
RecPerRow Records per row (multi-column list page) Integer
MultiDelete Delete records by multiple selection Boolean
SortType Sort type
0 - no sort
1 - single column sort
2 - multi-column sort		 Integer
PagerStyle Pager style:
1 - numeric pager
2 - nextprev pager		 Integer
TopPageLink Pager on top Boolean
BottomPageLink (v5.0+) Pager on bottom Boolean
ViewExport (v5.0+) View page export Boolean
ListExport (v8.0+) List page export Boolean
LinkOnLeft Links on Left Boolean
InlineDelete Inline delete Boolean
DetailViewPaging (v5.0+) Paging in view page Boolean
DetailEditPaging (v10.0+) Paging in edit page Boolean
ModalSearch (v11.0+) Use modal form for advanced search Boolean
ModalAdd (v2017.0+) Use modal form for add Boolean
ModalEdit (v2017.0+) Use modal form for edit Boolean
ModalUpdate (v2017.0+) Use modal form for update Boolean
ModalView (v2017.0+) Use modal form for view Boolean
RepeatColumns Repeat column count for radios and checkboxes Integer
AppRootFolder Application root folder String
RootRelativePath Root relative path String
EmailComponent Email component (deprecated) String
DeleteUploadedFile Delete unused uploaded file Boolean
AuditTrailPath Audit trail path String
RecipientEmail Receiver email String
SMTPServerUsername Smtp server user name String
SMTPServerPassword Smtp server password String
FavIcon (v7.0+) File path for FavIcon String
LoginOption (v7.0+) Login options: (comma separated list of following options, e.g. "AUTO,USER,ASK")
"AUTO" - Auto login until logout explicitly
"USER" - Save user name
"ASK" - Always ask for user name and password
 String
BlankPage (v8.0+) Generate blank custom page (deprecated) Boolean
UseButtonsForLinks (v10.0+) Use buttons for links Boolean
UseDropDownForAction (v10.0+) Use dropdown for action links Boolean
UseDropDownForListOptions (v10.0+) Use dropdown for list option links Boolean
MultiPageType (v10.0+) Multi page type:
"Tabs" - Bootstrap tabs
"Pills" - Bootstrap pills
"Accordion" - Bootstrap accordion		 String
UseDropDownForExport (v10.0+) Use dropdown for export links Boolean
CheckConcurrentUser Check concurrent user Boolean
ConcurrentUserSessionCount Concurrent user session count Integer
UserProfileSessionTimeout Concurrent user session timeout Integer
ResetConcurrentUser Reset concurrent user Boolean
CheckLoginRetry Check login retry Boolean
UserProfileMaxRetry Maximum login retry count Integer
UserProfileRetryLockout Login retry lockout time (minutes) Integer
ResetLoginRetry Reset login retry Boolean
CheckPasswordExpiry Check password expiry Boolean
UserProfilePasswordExpire Password expiry time (days) Integer
SetPasswordExpired Set password expired Boolean
ResendRegisterEmail Resend register email Boolean
AuditTrailToDB Write audit trail to database Boolean
AuditTrailTable Audit trail table name String
AuditTrailFieldDateTime Audit trail date/time field name String
AuditTrailFieldScript Audit trail script field name String
AuditTrailFieldUser Audit trail user field name String
AuditTrailFieldAction Audit trail action field name String
AuditTrailFieldTable Audit trail table field name String
AuditTrailFieldField Audit trail field field name String
AuditTrailFieldKeyValue Audit trail key value field name String
AuditTrailFieldOldValue Audit trail old value field name String
AuditTrailFieldNewValue Audit trail new value field name String
JavaScripts (v2018+) List of external JavaScripts String
StyleSheets (v2018+) List of external StyleSheets String
Note You can further define custom Project Level properties and put it in the "Advanced Settings" file (under "src\settings.xml" in the program folder). The setting is accessible in the UI via Tools -> Advanced Settings under the "Project" node. You can then access the custom properties in the template by PROJ.GetV("<property name>"). Make sure your property names do not conflict with PHPMaker's own project property names.

 

PROJ.MasterDetails Object

The PROJ.MasterDetails Object contains the array of all master/detail relationships defined in the current project. Each master/detail relationship has the following properties.

Property Description Data Type
MasterTable Master table name String
DetailTable Detail table name String
EnforceReferentialIntegrity (v10.0+) Enforce referential integrity Boolean
CascadeUpdate (v10.0+) Cascade update Boolean
CascadeDelete (v10.0+) Cascade delete Boolean

 

PROJ.CustomScripts Object

The PROJ.CustomScripts Object contains the array of all custom scripts defined in the current project. Each custom script has the following properties.

Property Description Data Type
ScriptType Script type (Server/Client) String
ScriptCodeType Script code type (Global/Table/Other) String
ScriptName Script name String
ScriptCtrlID Script control id String
ScriptL1Key Script level 1 key (table/other name) String
ScriptL2Key Script level 2 key (reserved for future use) String
ScriptCode Custom script code String

 

PROJ.Menus Object

The PROJ.Menus Object contains the array of menu items defined in the current project. Each menu item has the following properties.

Property Description Data Type
MenuId Menu id Integer
MenuText Menu display text String
MenuParentId

Menu parent id

 Integer
MenuGroup (v8.0+) Menu is a group item Boolean
MenuSource Menu source String
MenuExtUrl External url String
MenuAnonymous (v7.0+) Menu allows anonymous access Boolean
MenuSecurity Menu security settings String
MenuUrl Menu url (table name if table list page) String
MenuCustomUrl Menu use custom url Boolean
MenuLevel Menu level Integer
MenuShow Show this menu item Boolean
MenuDisplayOrder Menu display order Integer
MenuIconClass (v2018+) Menu icon class String
MenuNavbar (v2019+) Menu is shown in Navbar (top menu) String

 

DB Object

The DB Object points to the current database. You can access the current database properties by DB.PropertyName.

Property Description Data Type
DBID (v12.0+) Database id String
DBName Database name String
DBVar (v11.0+) Database variable String
DBType Database type String
DBPath Database path String
DBUseServerMapPath Maps the relative path of the database to the corresponding physical directory on the server (MS Access only) Boolean
DBPhyPath Database physical path String
DBSID Database schema id (Oracle) String
DBConnectionMethod Database connection method (MySQL):
"DIRECT" = direct connection
"URL" = URL connection 		String
DBURL If connection method is "URL", this parameter specifies the URL to the remote server (MySQL) String
DBHost Host name (MySQL/PostgreSQL/Oracle) String
DBPort Port number (MySQL/PostgreSQL/Oracle) String
DBEncoding Database encoding (MySQL/PostgreSQL/Oracle) String
DBUID Database user id String
DBPwd Database password String
DBQuoteS Database start quote character String
DBQuoteE Database end quote character String
DBConnstr Database connection string String
DBADOVer ADO version String
DBDBMSName DBMS name String
DBDBMSVer DBMS version String
DBOLEDBVer OleDb version String
DBProviderName Provider name String
DBProviderVer Provider version String
DBSchema Schema name String
MaxUploadSize Maximum upload file size Integer
SecUserLevelFld User level field name String
SecDefault Default security setting String
SecuUserIDFld User id field name String
SecUserProfileFld (v7.0+) User profile field name (used by the advanced security features: concurrent user login / Login retry / Password expiry) String
UseDynamicUserLevel Use dynamic user level Boolean
UserLevelTbl User level table name String
UserLevelIdFld User level id field name String
UserLevelNameFld User level name field name String
UserLevelPrivTbl User level privilege table name String
UserLevelPrivTblNameFld User level table name field name String
UserLevelPrivUserLevelFld User level user level name field name String
UserLevelPrivPrivFld User level privilege field name String
SecuParentUserIDFld Parent user id field name String

 

TABLE Object

The TABLE Object points to the current table. You can access the current table properties by TABLE.PropertyName.

Property Description Data Type
TblSchema (v7.0+) Table schema name String
TblName Table name String
TblVar Table variable String
TblType Table type (TABLE/VIEW/CUSTOMVIEW/REPORT/LINKTABLE) String
TblKey Table key String
TblGen Generate this table Boolean
TblGenList (v7.0+) Generation list for table scripts. Format:
info=1|list=0|... (Generate "info" = Yes, Generate "list" = No, ...)		 String
TblList Show table in menu Boolean
TblView Table view enabled Boolean
TblInlineEdit Table inline edit enabled Boolean
TblGridEdit (v5.0+) Table grid edit enabled Boolean
TblEdit Table edit enabled Boolean
TblEditConfirm (v5.0+) Edit needs confirmation Boolean
TblEditCaptcha (v7.0+) Edit use captcha Boolean
TblGridAdd (v7.0+) Table grid add enabled Boolean
TblAdd Table add enabled Boolean
TblAddReturnPage (v6.0+) Table add return page String
TblAddOpt (v6.0+) Table add option enabled Boolean
TblAddConfirm (v5.0+) Add needs confirmation Boolean
TblAddCaptcha (v5.0+) Add use captcha Boolean
TblInlineAdd (v5.0+) Table inline add enabled Boolean
TblInlineCopy (v5.0+) Table inline copy enabled Boolean
TblMultiUpdate (v5.0+) Table multi-update enabled Boolean
TblMultiUpdateConfirm (v5.0+) Multi update needs confirmation Boolean
TblAnonymous (v5.0+) Table anonymous access security Integer
TblIsMaster Table is a master table Boolean
TblIsDetail Table is a detail table Boolean
TblDelete Table delete enabled Boolean
TblCaption Table caption String
TblUpdatable Table is updatable Boolean
TblSQL Table SQL (Views only) String
TblError Table SQL error (Views only) String
TblSrchType Table search type:
"NONE" - none
"BASIC" - basic search
"ADVANCED" - advanced search
"BOTH" - both basic & advanced search		 String
TblSearchHighlight (v5.0+) Search highlight Boolean
TblSearchColor (v5.0+) Search highlight color (deprecated) String
TblSearch (v8.0+) Table advanced search enabled Boolean
TblBasicSearch (v8.0+) Table basic search enabled Boolean
TblExtendedBasicSearch (v8.0+) Table extended basic search enabled Boolean
TblBasicSearchDefault (v9+) Table basic search default value String
TblBasicSearchTypeDefault (v9+) Table basic search type default value String
TblExtSearchFldPerRow (v8.0+) Table extended basic search fields per row Integer
TblDefault Default table when site loads Boolean
TblCopy Table copy enabled Boolean
TblFilter Table filter (sql where clause) String
TblUserIDFld Table user id field name String
TblSecurity Table security settings String
TblUserIDAllow (v9+) Table allow view all security level Integer
TblExpanded (v7.0+) Expand the table generation list (for display) Boolean
TblLoaded Table is loaded Boolean
TblRptShowDetails Show report details (reports only) Boolean
TblRptShowGrandTotal Show report grand total (reports only) Boolean
OutputFolder (v11.0+) Output folder (custom files only) String
IncludeFiles (v11.0+) Include PHP files (custom files only) Boolean
TblReportType (v11.0+) Report type ("custom" for custom files) String
TblCustomSQL Table custom sql (Custom Views only) String
TblCustomError Error loading custom views / reports String
TblRptSrc Report source table (reports only) Boolean
TblRptIndent Report indentation by pixels (reports only) (deprecated) Integer
TblUseGlobal Use global settings Boolean
TblRecPerPage Records per page (list page only) Integer
TblRecPerPageList Dynamic values for records per page (list page only) String
TblPrinterFriendly (v6.0+) Printer Friendly Boolean
TblExportHtml Export to HTML Boolean
TblExportWord Export to Word Boolean
TblExportExcel Export to Excel Boolean
TblExportXml Export to XML Boolean
TblExportCSV Export to CSV Boolean
TblExportEmail (v7.0+) Export to email Boolean
TblExportPDF (v8.0+) Export to PDF Boolean
TblExportType (v7.0+) Export Type:
"SELECTED" = export selected records
"PAGE" = export current page
"ALL" = export all records		 String
TblImport (v2019+) Import from external files (Excel/CSV) Boolean
TblGridAddReturnPage (v2019+) Grid add return page ("_GRIDADD" = grid add page, "_GRIDEDIT" = grid edit page) String
TblGridEditReturnPage (v2019+) Grid edit return page ("_GRIDADD" = grid add page, "_GRIDEDIT" = grid edit page) String
TblRecPerRow Records per row (multi-column list page) Integer
TblMultiDelete Delete records by multiple selection Boolean
TblSortType Sort type
0 - no sort
1 - single column sort
2 - multi-column sort		 Integer
TblPagerStyle Pager style:
1 - numeric pager
2 - nextprev pager		 Integer
TblTopPageLink Pager on top Boolean
TblBottomPageLink (v5.0+) Pager on bottom Boolean
TblViewExport (v5.0+) View page export Boolean
TblListExport (v8.0+) List page export Boolean
TblLinkOnLeft Links on Left Boolean
TblInlineDelete Inline delete Boolean
TblDetailViewPaging (v5.0+) Paging in view page Boolean
TblDetailEditPaging (v10.0+) Paging in edit page Boolean
TblModalSearch (v11.0+) Use modal form for advanced search Boolean
TblModalAdd (v2017.0+) Use modal form for add Boolean
TblModalEdit (v2017.0+) Use modal form for edit Boolean
TblModalUpdate (v2017.0+) Use modal form for multiple update Boolean
TblModalView (v2017.0+) Use modal form for view Boolean
TblAuditTrail Table use audit trail Boolean
TblSendMailOnAdd Send email on add Boolean
TblSendMailOnEdit Send email on edit Boolean
TblSendMailOnDelete Send email on delete Boolean
TblShowBlankListPage Show blank list page Boolean
TblDetailShowCount (v7.0+) Show detail record count Boolean
TblDetailAdd (v9+) Allow detail add Boolean
TblDetailEdit (v9+) Allow detail edit Boolean
TblDetailView (v10.0+) Allow detail view Boolean
TblShowMultipleDetails (v10.0+) Show multiple details Boolean
TblEditReturnPage (v6.0+) Table edit return page String
TblMultiPageAdd (v6.0+) Table add multi page layout enabled Boolean
TblMultiPageEdit (v6.0+) Table edit multi page layout enabled Boolean
TblMultiPageView (v6.0+) Table view multi page layout enabled Boolean
TblMultiPageSearch (v8.0+) Table search multi page layout enabled Boolean
TblCheckConcurrentUpdate (v7.0+) Check for concurrent update Boolean
TblUserLevelPriv (v9+) Use table in dynamic user level security Boolean
TblDisplayRowCount (v10.0+) Display row count Boolean
TblUseButtonsForLinks (v10.0+) Use buttons for links Boolean
TblUseDropDownForAction (v10.0+) Use dropdown for action links Boolean
TblUseDropDownForListOptions (v10.0+) Use dropdown for list option links Boolean
TblMultiPageType (v10.0+) Multi page type:
"Tabs" - Bootstrap tabs
"Pills" - Bootstrap pills
"Accordion" - Bootstrap accordion		 String
TblUseDropDownForExport (v10.0+) Use dropdown for export links Boolean
LinkDBID (v12.0+) Link database id (for table type = "LINKTABLE" only) String
LinkTableName (v12.0+) Linked table name (for table type = "LINKTABLE" only) String
LinkTableType (v12.0+) Linked table type (for table type = "LINKTABLE" only) String
TblPageCaptions Page captions for multi page String

 

FIELD Object

The FIELD Object points to the current field. You can access the current field properties by FIELD.PropertyName.

Property Description Data Type
FldName Field name String
FldVar Field variable name (format: x_FldName) String
FldParm Field variable name without the "x_" prefix String
FldAlias Field alias name String
FldSourceName Field source name String
FldSourceTable Field source table name String
FldSourceField Field source field name String
FldType Field data type Integer
FldTypeName Field data type name String
NativeDataType Field native data type Integer
FldSQL (v12.0+) Field SQL (for custom field only) String
FldIsCustom (v12.0+) Field is custom field Boolean
FldSupport Field is supported Boolean
FldSort (v2017.0+) Field allows sort Boolean
FldSize Field size Long
FldUniqueIdx Field has unique index Boolean
FldZeroLen Field support zero-length string (MS Access only) Boolean
FldReq Field is required (NOT NULL) Boolean
FldIsPrimaryKey Field is primary key Boolean
FldAutoIncrement Field is auto increment field Boolean
FldAttribute Field ADO attributes Long
FldMin Minimum value for javascript validation String
FldMax Maximum value for javascripot validation String
FldErrMsg Error message if javascript validation failed String
FldValidate Validate format for javascript String
FldServerValidateArgs (v7.0+) Validate arguments (server side) String
FldClientValidateArgs (v7.0+) Validate arguments (client side) String
FldRequired Required field for javascript validation Boolean
FldPopCalendar Use popup calendar Boolean
FldGenerate Field generate enabled Boolean
FldList Field list enabled Boolean
FldExport (v6.0+) Field export enabled Boolean
FldView Field view enabled Boolean
FldEdit Field edit enabled Boolean
FldAdd Field add enabled Boolean
FldAddOpt (v6.0+) Field add option enabled Boolean
FldSearch Field search enabled Boolean
FldBasicSearch Field basic search enabled Boolean
FldExtendedBasicSearch Field extended basic search enabled Boolean
FldRegister Field enabled for registration page Boolean
FldSrchOpr Field search operator String
FldSrchOpr2 Field second search operator String
FldDefault Field default value String
FldSearchDefault (v9+) Field search default value String
FldSearchDefault2 (v9+) Field search default value 2 String
FldDbDefault (v7.0+) Field default value (database) String
FldCaption Field caption String
FldViewTag Field view tag String
FldViewThumbnail (6.0+) Field view as thumbnail (FILE type field only) Boolean
FldHtmlTag Field html tag String
FldTagSize Field html tag size Integer
FldTagMaxLength Field html tag maximum length Integer
FldTagValues Field user select value list String
FldHtmlTagReadOnly Field is read only Boolean
FldTagHiddenValue Custom value for hidden tag String
FldSelectType Field select type (Table/Values) String
FldTagLnkTbl Field link to table name String
FldTagLnkFld Field link to table key field name String
FldTagLnkDisplay Field link to table display field name String
FldTagLnkDisp2 Field link to table display field 2 name String
FldTagLnkDisp3 (v8.0+) Field link to table display field 3 name String
FldTagLnkDisp4 (v8.0+) Field link to table display field 4 name String
FldTagLnkOrderBy Field link to table order by field name String
FldTagLnkOrderType Field link to table order type (ASC/DESC) String
FldTagLnkDistinct Field link to table use distinct value Boolean
FldTagCols Field column count (TEXTAREA) Integer
FldTagRows Field row count (TEXTAREA) Integer
FldTagImgWidth Image width (IMG) Integer
FldTagImgHeight Image height (IMG) Integer
FldTagAType Href type String
FldTagATarget Href target type (A) String
FldTagAPrefix Href prefix (A) String
FldTagASuffix Href suffix (A) String
FldBold Field bold enabled Boolean
FldItalic Field italic enabled Boolean
FldAlign Field alignment String
FldFmtType Field format type:
"Currency" - format as currency
"Date/Time" - format as date/time
"Number" - format as number
"Percent" - format as percent
"String" - format as string		 String
FldDtFormat Field date format:
  • 0 - Default - based on locale file
  • 1 - DateTime - Date and time, format based on locale file
  • 2 - Date - Date only, format based on locale file
  • 3 - Time(AM/PM) - 12-hour with AM/PM
  • 4 - Time - 24-hour
  • 5 - Ymd
  • 6 - mdY
  • 7 - dmY
  • 8 - YmdHis
  • 9 - mdYHis
  • 10 - dmYHis
  • 11 - ymd
  • 12 - mdy
  • 13 - dmy
  • 14 - ymdHis
  • 15 - mdyHis
  • 16 - dmyHis
Integer
FldNumDigits Field number of digits after decimal Integer
FldIncLeadDigit Field include leading digit Integer
FldUseParen Field use parenthesis for negative Integer
FldGpDigits Field group digits Integer
FileNameFld File name field name (FILE) String
FileTypeFld File type field name (FILE) String
FileSizeFld File size field name (FILE) String
ImageWidthFld Image width field name (FILE) String
ImageHeightFld Image height field name (FILE) String
FldHrefFld Field hyperlink to field name String
FldHrefFldOrig (v5.0+) Href use original value Boolean
FldStrFunc Field string function name String
FldUseDHTMLEditor Use HTML editor (MEMO) Boolean
FldMemoMaxLength Maximum length for memo field (list page only) Integer
FldSelectSize Multiple selection list size Integer
FldSelectMultiple Use multiple selection list Boolean
FldSelectFilter Field select filter String
FldAutoFillSourceFields (v9+) Field auto fill source fields String
FldAutoFillTargetFields (v9+) Field auto fill target fields String
FldParentSelect Dynamic combobox parent field name String
FldParentSelect2 (v9+) Dynamic combobox parent field name 2 String
FldParentSelect3 (v9+) Dynamic combobox parent field name 3 String
FldParentSelect4 (v9+) Dynamic combobox parent field name 4 String
FldSelectFilterFld Dynamic combobox filter field name String
FldSelectFilterFld2 (v9+) Dynamic combobox filter field name 2 String
FldSelectFilterFld3 (v9+) Dynamic combobox filter field name 3 String
FldSelectFilterFld4 (v9+) Dynamic combobox filter field name 4 String
FldParentSelectTbl (v12.0+) Dynamic combobox parent field table name String
FldParentSelectTbl2 (v12.0+) Dynamic combobox parent field table name 2 String
FldParentSelectTbl3 (v12.0+) Dynamic combobox parent field table name 3 String
FldParentSelectTbl4 (v12.0+) Dynamic combobox parent field table name 4 String
FldSelectAllowAdd Ajax add to combo box Boolean
FldQuoteS Field start quote character String
FldQuoteE Field end quote character String
FldColumnWidth List page field column width String
FldColumnWrap List page field column wrap Boolean
FldAggregate Field aggregation function name String
FldGroupBy Field grouping sequence (reports only) Integer
FldOrderBy Field ordering sequence Integer
FldOrder Field order type (ASC/DESC) String
FldGroupByShowSummary Field grouping show summary (reports only) Boolean
FldRptAggSum Aggregate field sum (reports only) Boolean
FldRptAggAvg Aggregate field average (reports only) Boolean
FldRptAggMin Aggregate field minimum (reports only) Boolean
FldRptAggMax Aggregate field maximum (reports only) Boolean
FldRepeatColumns Repeat column count for radios and checkboxes Integer
FldUploadPath Field level upload path String
FldUploadMultiple (v10.0+) Upload multiple fields (comma separated) Boolean
UploadAllowedFileExt (v11.0+) Allowed upload file extensions (comma separated) Boolean
UploadMaxFileSize (v11.0+) Upload maximum file size Long
UploadMaxFileCount (v11.0+) Upload maximum file count (multiple upload only) Long
FldCheckDuplicate Check duplicate for field Boolean
FldPageIndex Field page index (multi page add/edit) Integer
FldAjax Field use Ajax (deprecated) Boolean
FldAutoUpdateValue (v5.0+) Field auto update value String
FldUploadResize (v5.0+) Resize file on upload (FILE) Boolean
FldResizeWidth (v5.0+) Resize file width Integer
FldResizeHeight (v5.0+) Resize file height Integer
FldMultiUpdate (v5.0+) Field enabled multi-update Boolean
FldTitle (v5.0+) Field title attribute (INPUT) String
FldAlt (v5.0+) Field alt attribute (IMG) String
FldEditCustomAttributes (v5.0+) Field edit tag custom attributes String
FldViewCustomAttributes (v5.0+) Field view tag custom attributes String
FldTagACustomAttributes (v8.0+) Field href tag custom attributes String
FldResizeQuality (v5.0+) Resize file quality Integer
FldEditTableField Field edit table field (deprecated) String
FldAutoFill (v6.0+) Field auto fill Boolean
FldSelectForceSelection (v6.0+) Field select force selection Boolean
FldMemoCRLFReplace (v6.0+) Field replace CrLf with <br> Boolean
FldTooltipFld (v7.0+) Field tool tip field String
FldTooltipWidth (v7.0+) Field tool tip width (px) Long
FldVirtualLookup (v7.0+) Field use virtual lookup (for sort and search) Boolean
FldVirtualLookupSearch (v7.0+) Use textbox for virtual lookup search Boolean
FldViewTemplate (v9+) Field custom view template String
FldEditTemplate (v2018+) Field custom edit template String
FldOptionTemplate (v12.0+) Optional template for auto fill/auto suggest String
FldDropdown (v12.0+) Use bootstrap dropdown for field Boolean
FldDropdownWidth (v12.0+) Dropdown width Integer
FldDropdownHeight (v12.0+) Dropdown height Integer
FldModalLookup (v2017.0+) Use modal form to search and select from lookup table Boolean
FldModalLookupPageSize (v2017.0+) Modal lookup page size Integer
FldCheckPasswordStrength (v2018.0+) Check password strength (Password field) Boolean
FldGeneratePassword (v2018.0+) Generate password (Password field) Boolean

 

PROJ.LINKDBS Object

The PROJ.LINKDBS array contains of all link databases defined in the current project.

Each link database has the same properties as the DB object above.

 

 


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