Specifications

CHAPTER 3 Managing the Database
Users Guide 81
Modifying database preferences
To modify database preferences, select Design>Options from the menu bar.
Some preferences are specific to the database connection; others are specific to
the Database painter.
Preferences on the
General property page
The Connect To Default Profile, Shared Database Profiles, Keep Connection
Open, Use Extended Attributes, and Read Only preferences are specific to the
database connection.
The remaining preferences are specific to the Database painter. For information
about modifying these preferences, see Connecting to Your Database.
Table 3-4: Database painter preferences
Preferences on the
Object Colors property
page
You can set colors separately for each component of the Database painter’s
graphical table representation: the table header, columns, indexes, primary key,
foreign keys, and joins. Set a color preference by selecting a color from a
drop-down list.
You can design custom colors that you can use when you select color
preferences. To design custom colors, select Design>Custom Colors from the
menu bar and work in the Custom Colors dialog box.
Database
preference What InfoMaker does with the specified preference
Columns in the
Table List
When InfoMaker displays tables graphically, eight table
columns display unless you change the number of columns.
SQL Terminator
Character
InfoMaker uses the semicolon as the SQL statement terminator
unless you enter a different terminator character in the box.
Make sure that the character you choose is not reserved for
another use by your database vendor. For example, using the
slash character (/) causes compilation errors with some
DBMSs.
Refresh Table List When InfoMaker first displays a table list, InfoMaker retrieves
the table list from the database and displays it. To save time,
InfoMaker saves this list internally for reuse to avoid
regeneration of very large table lists. The table list is refreshed
every 30 minutes (1800 seconds) unless you specify a different
refresh rate.