Programming Database Fields

This page is currently incomplete, but you can find information about this topic at the links below:

- addfield -- The addfield statement adds a new field to the current database (on the end).
- autoallfieldwidths -- The autoallfieldwidths statement automatically sets the width of all fields based on the data in each field.
- autofieldwidth -- The autofieldwidth statement automatically sets the width of the current field based on the data in it.
- automaticfieldchoices -- The automaticfieldchoices statement updates the current field's Choice list with actual data in the database.
- cell -- The cell statement enters a value into the currently active field (i.e. cell).
- commonfieldspopup -- The commonfieldspopup statement pops up a list of common fields, and changes the current field specifications when a field is chosen from this menu.
- constructfields -- The constructfields statement creates one or more new fields based on a template.
- deletefield -- The deletefield statement deletes the current field from the database.
- duplicatefield -- The duplicatefield statement duplicates the current field.
- editfieldname -- The editfieldname statement opens the data sheet window's field properties inspector and selects the field name.
- fieldname -- The fieldname statement changes the name of the current field.
- fieldtype -- The fieldtype statement changes the data type of the current field.
- fieldtypes -- The fieldtypes statement returns a carriage return delimited array with list of fields and field data types.
- findreplacedialog -- The findreplacedialog statement opens the Find & Replace dialog.
- hidecurrentfield -- The hidecurrentfield statement hides the current field in the data sheet.
- hidethesefields -- The hidethesefields statement hides specific fields in the data sheet, making all others visible.
- insertfield -- The insertfield statement inserts a new field into the database in front of the current field.
- mergefieldsdialog -- The mergefieldsdialog statement opens the standard Merge Fields dialog.
- movefieldbefore -- The movefieldbefore statement moves the current field to a new position.
- setfieldnames -- The setfieldnames statement changes the names of all database fields at once.
- setfieldproperties -- The setfieldproperties statement modifies one or more properties (name, data type, formula, etc.) of the current field.
- showallfields -- The showallfields statement makes every field in the data sheet visible.
- showthesefields -- The showthesefields statement makes specific fields in the data sheet visible, hiding all others.
- splitfielddialog -- The splitfielddialog statement opens the standard Split Field dialog.

History

Version | Status | Notes
10.0 | Updated | Carried over from Panorama 6.0, with some updates.