Table Flags

This tab page has all the options that are table-oriented.

Open/Set Tables Readonly

When this option is turned ON, the default open mode for all tables is read-only. You can view records but cannot change them. If dbAdminMode is set to Database Mode or Full Mode, you can click the read-only icon in the first status bar pane to toggle between read-only and read/write. If the table is read-only, you can still type in values in the data grid to find records, but no changes are kept and saved. The default is ON.

When this option is turned ON, all the columns of the opened table will be enumerated. If any of them relates to a parent table, Database Explorer attempts to open that table. If that is successful, the data source of a control that would map to childtable.column will be replaced by parenttable.column data source. The big advantage of this option is that you cannot enter a value in a childtable.column of which no parent record exists. This increases data integrity. The default is OFF.

When this option is ON, all the tables in your file list will be opened and checked one-by-one to see if there are columns that relate to the table you are trying to open. If there are child tables, Database Explorer will open them. The big advantage of this option is that you cannot easily—read by accident—delete records from the main table while child records exist. The downside of this configuration option is that opening a table will be slower, especially when the file list contains many tables and the tables are opened via a connectivity kit that requires login, etc. The default is OFF.

Zerofile Allowed

There is a single-user feature in DataFlex that erases all the data from a table. This action is always irreversible, and zerofile should be used with care. Allowing zerofile enables the option on the file pull-down and local menu. The default is OFF.

High Data Integrity

When writing to a table, Windows might buffer the writes to disk. This buffering can be disabled by closing the table temporarily after each save or delete. This option sets the DF_HIGH_DATA_INTEGRITY global attribute. The default is OFF.

You must check this option to enable the "Delete All (Filtered) Records" button in the database toolbar.

Create Temporary Indexes

This applies to SQL databases opened via one of the Data Access CLI connectivity kits. Turning on this option cycles through the columns of a table to see whether they are part of an index. If not, a temporary index is created. Temporary indexes use a different icon in the list of indexes for a table and make it possible to find on any column or sort the data in the grid on any column. The temporary index will be removed when the table is closed.

Note that the creation of temporary indexes can be initiated by the user via the indexes node under each table node in the list of tables.

Allow Open Unlisted Tables

This is a security feature. Developers may have reasons to hide tables from the list of tables (file list), and allowing users to open these tables is then not correct. The default for this option is the dbAdminMode setting, which is On/DDB for Studio installations and Off for client installations.