Field built-in tag

Usage:
<Field Name=value Type=value DisplayAs=value Caption=value>

Use the Field tag to specify each field in the table (if a field does not already exist, Arcos will add it to the table if modification is allowed). For existing fields, the field order specified here does not need to match any implied order in the table. Arcos matches the fields purely on an equivalence of names.

The order of the field definitions within a table definition determines the order in which records are displayed on all the web pages that use the table definition. You can change the order elsewhere (for example, by using a template), which is useful if you want different orders on different pages.

Name

The name used by Arcos.

Type

One of the list of components named "Recordset_Field_xxx", where the type is xxx. Of special note are:

The most common field types are listed below.

DisplayAs

One of the list of components named "Recordset_Field_{Type}_xxx" lists the available DisplayAs values for each Type. For text fields, DisplayAs="textarea" tells Arcos to display as a multi-line input box instead of a single line.

Caption

Some display components automatically insert titles for fields. If the Caption property is not used, then Arcos uses the field name. If the caption is specified, then Arcos uses this.

Field types

These are the most common field types, along with their DisplayAs modes.

 

Type DisplayAs
  Edit Value
bool A boolean type - A checkbox Text
radio A couple of true/false radio buttons Text
selectlist A true/false pulldown list Text
currency A currency type - A textbox Text
date A date representing type - DD/MM/YY pulldown lists Text
datetime A date and time representing type - DD/MM/YY HH/MM/SS pulldown lists Text
float A floating point type - A textbox Text
integer An integer type - A textbox Text
memo A string type with no length limit (can be inefficient) - A text area Text
reference A type to define a foreign key relationship, with extra properties in order to display other fields based on this relationship - A pulldown list of "display" fields Text of foreign key
csvlookup A pulldown list of "display" fields Text of "display" field
dlookup A pulldown list of "display" fields Text of "display" field
grouped Multiple pulldown lists of linked "display" fields Text of foreign key
radio A set of radio buttons of "display" fields Text of foreign key
sequence A read only integer used as unique identifiers for table entries - Read only text Text
static A read only string type, its component is used as the base class for all the other field type components - Read only text Text
string A string type, whose maximum length must be specified using a "Size" attribute - A textbox Text
file A file selection field Text
password A password field  
password change A double password field (to allow and check user has entered the same password twice)  
time A time representing type - HH/MM/SS pulldown lists  
url A URL representing type - A textbox  
image The image that the URL points to  
string A textbox