List of Tables Flags
This tab page shows the options that are effective for the list of tables’ tree view.
Keep Selected Columns
When selecting columns for a rebuild data view, you can keep the selected columns for the next time or let their select state be reset. The option is available to make life easier if you decide to add a column to the data view later. The default is OFF.
Sort The Items
When this configuration option is ON, all entries in the list of tables will be automatically sorted in alphabetical order when added to the list. The default is OFF; most users prefer the original file list order to start with. Sorting afterwards is possible.
Use Tooltips On List Of Tables
A treeview control has a feature to show the value of an item in a tooltip if the value is truncated by the width of the control. When this configuration flag is true, the tooltip is activated. The default is ON.
Show Column Numbers
When this configuration option is ON, each column in the list of columns for a table shows its sequence number in the table. Column numbers appear in front of the column name. The default is OFF.
Show Table Numbers
When this configuration option is ON, each table in the list of tables shows its file list slot number. Table numbers appear by default in front of the table name. The default is OFF. If the table number helps you select the table in the treeview, turn the option ON.
Place Table Number Before Table Name
This configuration option tells Database Explorer to show the number of the table—when turned ON—in front of the table name or at the end. If you want to sort table names alphabetically, you should place the number of the table at the end of the tree view entry. The default is ON.
Prefix Table Numbers With Zeroes
For a proper sort of tree view items, the table numbers should have the same length. Tree view controls sort on text value, making a “2” appear after “11”. When the value of “2” is shown as “02”, the sort would be different and, to most people, correct. This option tells Database Explorer to add table numbers with zeroes as a prefix. The default is ON.
Hide Tables From Filelist
DataFlex offers a feature for developers to hide tables from the file list for end-users in their tools. When the user display name (DF_FILE_DISPLAY_NAME) starts with an AT (@) sign, the table entry should be left out of lists with tables. Database Explorer respects this feature, and when this option is ON, those tables are not shown as part of the list of tables. The default value is ON.
Rebuild DataView With Columns In Select Order
When rebuilding the data view, Database Explorer can use the sequence number of the selected columns for the grid columns and DEO control or the “pick” order. This configuration option is meant to express how it should be done. The default is ON.
Display Marker When Tables Are Hidden From List Of Tables
The option to exclude tables from the list of tables can lead to confusion because some tables are not shown. This configuration option tells Database Explorer to show an asterisk after the root entry labeled “Tables” to indicate that there are tables excluded. If you want to use the exclusion as a replacement for the “skip protected tables” or want to hide them for end-users, you might not want to inform them via the asterisk that tables were excluded. The default is OFF.
Expand Table Entry On Open
When clicking on a table entry in the tree view with the intention to open the table, you might want to explore and use the nested branches such as indexes and columns. When this configuration option is ON, the entry will automatically expand. The default is OFF.
Add Recent OpenAs Tables
This configuration option makes Database Explorer show the last used OPEN AS tables in the list. The names will be grouped under the “Tables, Opened As…” branch. To get this feature working, you need to have the MRU choice “Store Recent Tables” turned ON. Since this option does not only store OPEN AS tables but also “normal” tables, you might want to increase the value in the amount input form. The default is OFF.
Detect Changes By Date/Time
During development, it is quite normal for new tables to be added to the file list. Adding new tables—or making modifications—is done via Database Builder. When you keep Database Explorer open during these actions, the list of tables will be as it was when the tool started. This configuration option keeps track of the date and time that the file list was modified, and when switching to Database Explorer, a question will pop up when a change is detected. You can decide to load the changes or delay the change display. The default is OFF.
Close Open Table When Root Item Is Clicked
This option closes any open table when the user clicks the root item in the 'List of Tables' tree view when checked.
Display Index Names or Numbers
This option determines whether the index nodes in the tree view display index names or numbers. Index names will only display for drivers that support this feature.