Querying Tables and Table Columns

The Table Designer Properties form shows properties of the currently selected table or column. Invoke this form by selecting File>Properties or right-clicking on a table or column name in the right-hand pane and selecting Properties.

You can leave the Table Designer Properties form active while you navigate around the table schema. You can use this form to change the name of a table or column and to set the data properties of columns (how the data is returned: STRING, INTEGER or REAL [REFNO is equivalent to STRING]). The default data type is STRING which is usually adequate for most reporting purposes (although you may wish to change the default size of 22 to something bigger).

The Table Schema Properties form lets you change the project schema file associated with the table schema. Bring up this form by selecting File>Schema Properties. The form also allows you to specify how the table schema file should point to the project schema file ‑ using relative or absolute pathnames.