Home
Personal Info and Holiday Snaps How to contact Kevin Millican Java Chatroom Software for Nokia 9200 Series and other Symbian OS6 Programming Articles Pocket Computer & PDA Links Software for Psion Series 5 / 5mx / Revo(+) / Series 7 / netBook / Osaris / Geofox / Ericsson MC218 and other ER3-ER5 devices PDA Articles General Computing Links Psion Series 3a/c/mx Software PC Articles Christian Links PC Software Technical Articles Metallurgy & Welding Links Software for Other Platforms & Web Development Miscellaneous Articles General Links Main Menu

PsiDat Field Modifiers

Category Modifier Details
Calculation <CIZ> 'Calculate If Zero' - numeric calculation is only performed if field value is empty or zero.
Calculation <MOD> Modified date/time

This field will update to the current time whenever it is recalculated.

If 'Auto-recalc' is ticked on the main menu, then this field will be updated whenever any field is edited.
Display <CUR> 'CURrency' - display doublefloat field as a currency. The format is set in the general options dialog and uses the following global variables :-

ShowCurrencies% (-1 or 0, default = 0)
CurrencyPre$ (10 character max string)
CurrencyPost$ (10 character max string)
CurrencyBrackets% (1 or 2, 2 = use brackets for negative values)
Display <DMS1> Display lat/long fields as decimal degrees.
eg.
35.96160
Display <DMS2> Display lat/long fields as Degrees, Decimal Minutes (2dp)
eg.
3557.70'N
Display <DMS3> Display lat/long fields as Degrees, Decimal Minutes (3dp)
eg.
3557.696'N
Display <DMS4> Display lat/long fields as Degrees, Minutes, Seconds
eg.
3557'41"N
Display <DMS5> Display lat/long fields as Degrees, Minutes, Decimal Seconds
eg.
3557'41.8"N
Display <DT1> Displays a DoubleFloat number as the equivalent datetime.

DateTime field values can be used in calculations resulting in a numerical result. The <DT1> field modifier causes this number to be displayed as a datetime string.
Display <DT2> Displays a DoubleFloat number as the equivalent date.

DateTime field values can be used in calculations resulting in a numerical result. The <DT2> field modifier causes this number to be displayed as a date string.
Display <DT3> Displays a DoubleFloat number as the equivalent time.

DateTime field values can be used in calculations resulting in a numerical result. The <DT3> field modifier causes the time component of this number to be displayed as a time string.
Display <GRY> 'GReY' - Display the field with a grey background (will not do anything on pre-ER5 machines).

NB: This modifier will not behave as indicated until the table is reopened.
Display <INF> 'INFormation' - display the field contents as well as the record number when 'Show Record Info' is ticked on the main menu.
Display <LC> Display the field in lower case.
Display <LIN> 'LINe' - The field is a section divider.

A horizontal line will be placed over the fieldname to indicate a section start. This can be useful if the table contains a large number of fields.

This modifier is also used as a jump location when the user presses '.' while browsing. The jump fieldname is shown flashing at the bottom of the screen and the user can move to a desired jump location using the cursor keys and the Enter key.
Display <SPV> 'SPlit View' - use this field as the default column for the listing in split list view.
Display <UC> Display the field in upper case.
Display, Input <MF> Male/Female text (Bit Fields)
Display, Input <TF> True/False text (Bit Fields)
Display, Input <YN> Yes/No text (Bit Fields)
Display, Lookup <L2F> 'Lookup 2 Fields' - makes a custom lookup/help popup display the first two text fields instead of only the first one.
Display, Lookup <L3F> 'Lookup 3 Fields' - makes a custom lookup/help popup display the first three text fields.
Display, Lookup <L4F> 'Lookup 4 Fields' - makes a custom lookup/help popup display the first four text fields.
Display, Lookup <MXW> 'MaX Width' - forces help/lookup popup to maximum width instead of being related to the target field width.

The <MXW> modifier can be useful in conjunction with the <L2F>, <L3F>, and <L4F> modifiers
Exports <HTM> HTML source.

Prevents conversion of newlines and various HTML special characters in this field when exporting to HTML. By default, special characters are converted so that HTML output displays text exactly as written.

This is obviously undesirable for HTML source because it would prevent links etc. from working as planned. The <HTM> modifier prevents all these conversions and allows 'raw' output of the field contents.
Exports <NCB#> 'No Column Break' - prevents this field from causing an HTML column break (ie. joins it to the next one). The value of # affects how this field is separated from the following one :-

<b><NCB1></b> insert a line break (<BR>)
<b><NCB2></b> insert a space character
<b><NCB3></b> no separation
Exports <NOE> 'NO Export'

This modifier switches the field off by default for text and HTML exports. It can still be switched on manually using the 'Options' button in the export dialog box before performing the export.
Exports, Special <HNM> 'Html NaMe' - If this modifier is present, then the contents of this field should be used as the basis of the filename for single record HTML output.

PsiDat will append the '.htm' extension automatically - it should not be included.
Exports, Special <HTI> 'Html TItle' - Use this field for the default page title when exporting HTML.
Exports, Special <ICN> 'ICoN source' - used with memo fields to insert an image at top left of the memo text when exporting HTML.

Usage: <ICN>#
where # is the field number that contains the image filename.

eg. if field 3 contains the text 'mypic.gif' then a memo field using the modifier:-

<ICN>3

will put an image in the top left corner called 'mypic.gif'
Input <ST> 'STart' Causes the cursor to start at the beginning of the text instead of the end.

The main use for this modifier is with units contained in a standard Help popup.

For example, if the helps had values; "mm", "cm", "in", "pixels" etc., selecting "cm" would put "cm" in the field and place the cursor in front of it ready to enter a value.
Input, Lookup <AP1> Append help text instead of replace (with comma separator).

Normal behaviour of help/lookup text is to replace the contents when an item is selected from the popup. However, sometimes there is a need to build a string from several selections. The <AP1>, <AP2>, <AP3>, <AP4> & <AP5> modifiers allow this with various options on the separator string.
Input, Lookup <AP2> Append help text instead of replace (with comma+space separator).

See <AP1> for fuller description.
Input, Lookup <AP3> Append help text instead of replace (with space separator)

See <AP1> for fuller description.
Input, Lookup <AP4> Append help text instead of replace (with '/' separator)

See <AP1> for fuller description.
Input, Lookup <AP5> Append help text instead of replace (with ' / ' separator)

See <AP1> for fuller description.
Input, Lookup <NDR> 'No DRilldown' - prevents the user from pressing the tab key in a lookup to edit the lookup table.
Input, Lookup <NOA> 'NO Addition' - Do not add new text to help entries.

The default behaviour with help popups is to offer the user the option to add any unrecognised input to the helps files. This modifier switches off this ability.
New Record Autofills <+1> Increment number

The value shown in this field +1 will be inserted in any new record created.
New Record Autofills <CD> 'Copy Down'

The current value of this field will be used as an autofill value when creating a new record.
New Record Autofills <DEF> 'DEFault value'

This modifier is unusual in that it must be the last one used in the list of modifiers.

Eeverything following <DEF> is used as a default value when creating a new record.

Examples:

To indicate a bit field should default to true :-
<DEF>1

To put the words "Not specified" in a text field:-
<DEF>Not Specified

To default to the value 100 in a numerical field:-
<DEF>100

New Record Autofills <NOW> Use the current datetime or GPS fix when creating a new record.

This is frequently used to datestamp new records.

It will also force a RealMaps/GPS position read on numeric fields that are set to be lat/long coordinates.
Printing <NOP> 'NO Print' - do not print this field when using the simple print facility.
Special <SQL> Autofilter
When a user presses shift-F, the contents of any of the fields that use the <SQL> modifier are used to create and activate an SQL filter based on those values.
Special <SUB> Makes the field a key to a sub-table. The name of the sub-table must follow the <SUB> modifier. If other modifiers follow, then put a space character after the sub-table name.

It is possible to have more than one <SUB> modifier to relate to a number of subtables, eg.

<SUB>Mytable1 <SUB>Mytable2
Special, Input <LCK> 'LoCK' - prevent the field from being edited. Useful for the key fields of sub-tables to prevent record flyaway (and possible untrappable errors).
Summary Operators <AVG> Summary operator - Average

The average of the values of all the records in the view will be calculated and shown in reports and tabular HTML exports.
Summary Operators <CNT> Summary operator - Count

The number of records in the view will be counted and shown in reports and tabular HTML exports.

The exact behaviour can be modified by the 'Count Zero Values' option in the general preferences.
Summary Operators <MAX> Summary operator - Maximum

The maximum value for this field will be recorded and shown in reports and tabular HTML exports.
Summary Operators <MIN> Summary operator - Minimum

The minimum value for this field will be recorded and shown in reports and tabular HTML exports.
Summary Operators <SUM> Summary operator - Sum

The sum of the values of all the records in the view will be calculated and shown in reports and tabular HTML exports.

Back

<< Back