table

The table is of course the heart of the database. In Andromeda you define your columns, then define a table and place the columns into the table.

Example

table table_id:
   # Required
   module: module_id
   description: string
   # Optional
   uisort: Y/N
   nomenu: Y/N
   capspk: Y/N
   # This flag is optional
   fkdisplay: dynamic
   # Comments are optional
   comments: > 
   # At least one column placement is required
   column column_id:
      #...possible property assignmnents to the column
   # Other optional nested definitions
   foreign_key table_id:
      #...possible property assignments to the foreign key
   group group_id:
      #...possible property assignments to the group
   projection projection_id:
      #...possible property assignmnents to the index
   index index_id:
      #...possible property assignmnents to the index
   upsave upsave_id:
      #...possible property assignments to the upsave
   history history_id:
      #...possible property assignments to the history

Properties

table table_id. The first line of a table definition begins with the keyword 'table', a space, and then the unique table name (table_id) followed by a colon.

description. The friendly name of the table as used on the menu, as page titles, and the like.

nomenu. A Y/N flag to keep this table off the menu. This can be overridden by a table.group definition.

capspk. Causes the primary key columns to be converted to uppercase when a new row is inserted.

uisort. A numerical value that determines this table's placement on the menu with respect to other menu entries and tables in the same module.

fkdisplay. Set this to 'dynamic' to make use of the Ajax Dynamic List (possibly one of the coolest Andromeda features), or leave it off to have lookups occur with conventional HTML SELECT widgets.

Nested Objects

The following objects can be placed within a table:

Previous: menu Next: table.group