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:
sequence
- automatically generated number for use as primary key.memo
- variable length text field of unlimited size.reference
- link to a field in another table.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.
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 |