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.
The Connect To Default Profile, Shared Database Profiles, Keep Connection Open, Use Extended Attributes, and Read Only preferences are database-connection-specific preferences. For information about modifying these preferences, see the Resource Guide.
The remaining preferences are specific to the Database painter, and are shown in Table 16-4.
Database preference |
What PocketBuilder does with the specified preference |
|---|---|
Columns in the Table List |
When PocketBuilder displays tables graphically, eight table columns display unless you change the number of columns. |
SQL Terminator Character |
PocketBuilder uses the semicolon as the SQL statement terminator unless you enter a different terminator character in the box. |
Refresh Table List |
When PocketBuilder first displays a table list, it retrieves the table list from the database and displays it. To save time, PocketBuilder saves this list internally for reuse to avoid regenerating very large table lists. The table list is refreshed every 30 minutes (1800 seconds) unless you specify a different refresh rate. |
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 for 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.
