Home

This version of Pendragon Forms will automatically detect the PSC Momentum scanning module. To scan a barcode with the PSC Momentum module, simply press the MemoPad button.

Scripting Commands

The following commands enable you to select, insert, update and delete records in forms. In addition to providing more control, this feature is very handy for storing persistent state. For example, they can be used to store autonumbering variables that will persist even if a Palm device is hard-reset and the application is reloaded.

The following commands enable you to select, insert, update and delete records in forms. In addition to providing more control, this feature is very handy for storing persistent state. For example, they can be used to store autonumbering variables that will persist even if a Palm device is hard-reset and the application is reloaded.

In the following, SELECTing a record has an effect similar to that of the Filter function in Pendragon Forms. The UPDATE and DELETE statements take effect on the selected records.

Only one selection is in effect at any time, so if a SELECT or INSERT statement follows another SELECT or INSERT statement, the previous selection is cancelled.

SELECT <formname> WHERE FIELD <number> IS <expression>

Selects all the records for the specified form where the numbered field has a specific value.

Examples:

SELECT Accounts WHERE FIELD 1 IS "USA"

SELECT Users WHERE FIELD 1 IS $3

SELECT MATCHING <formname>

Selects all records in the specified form that match the record in which the script is executing. This selects the subforms for the current record in form <formname>. The selection is made by comparing the names of the first 10 fields on the current form and on the named form. Fields whose names match must have also have matching values for a selection to be made.

SELECT ALL <formname>

Selects all the records in the specified form.

INSERT INTO <formname>

Creates a new record in the specified form and selects it.

DELETE

Deletes all the selected records. Use extreme caution with this statement.

UPDATE FIELD <number> = <expression>

Updates the selected records by setting the value of the numbered field to the specified expression.

Example:

This example shows how to implement a persistent autonumber field. The form "Counters" has two columns. The first stores an ID number, and the second column stores the last counter value, and is names the same as the counter field on the main form. Because Counters is a form, it's values are backed up with each synchronization. The LOOKUP statement is used to lookup the existing value of the counter field.

LOOKUP 1 WITHIN Counters

ANSWER = ANSWER + 1

SELECT Counters WHERE FIELD 1 IS 1

DELETE

INSERT INTO Counters

UPDATE FIELD 1 = 1

UPDATE FIELD 2 = ANSWER

Hiding the End Button in Record View

In some applications, it is preferable to hide the End button in Record View. To enable this and similar features, several new scripting commands have been added. These statements should be used in the OPEN event for the relevant form.

ENABLE [ ENDBUTTON | NAVBUTTONS | ICONS | MENUS | SHORTCUTS]

DISABLE [ ENDBUTTON | NAVBUTTONS | ICONS | MENUS | SHORTCUTS]

ENDBUTTON
Shows/hides the End-button in both Record View and Field View.

NAVBUTTONS
Shows/hides the navigation buttons in Record View.

ICONS
Shows/hides the timestamp/datestamp icons in text fields in Field View.

MENUS
Disables certain menu items including

Clone
Mark All Changed
Print
Print All
Acquire Barcode
Acquire GPS

SHORTCUTS
Shows/hides the shortcut icons in Record View. See below.

Shortcut Icons in Record View

Shortcut icons in Record View enable a user to Zoom in to fields on a form.

LIMITATION: Scripting functions may not be consistent with Shortcuts in this version. That is, the ENTER and EXIT events may not fire as expected. We recommend against using this feature if you are using these events in Record View.

Shortcuts can be activated by adding the following script to your form:

OPEN:
ENABLE SHORTCUTS