Setting preferences in the Database Preferences dialog box

Shared Database Profiles

Specifies the pathname of the file containing the database profiles you want to share. You can type the pathname or click Browse to display it.

“Sharing database profiles”

Connect to Default Profile at Startup

Specifies when InfoMaker connects to the database. Select or clear the check box as follows:

• Select the check box The next time you start InfoMaker, it automatically connects to the database at startup and stays connected throughout the session until you exit.

• Clear the check box (Default) The next time you start InfoMaker, it connects to the database only when you open a painter requiring a connection.

Connect DB at Startup in the online Help

Connect to Default Profile

Controls whether the Database painter establishes a connection to a database using a default profile when the painter is invoked. If not selected, the Database painter opens without establishing a connection to a database.

Connect to Default Profile in online Help

Read Only

Specifies whether InfoMaker should update the extended attribute system tables and any other tables in your database. Select or clear the Read Only check box as follows:

• Select the check box Does not update the extended attribute system tables or any other tables in your database. You cannot modify (update) information in the extended attribute system tables or any other database tables from the Report and Form painters when the Read Only check box is selected.

• Clear the check box (Default) Updates the extended attribute system tables and any other tables in your database.

Read Only in the online Help

Keep Connection Open

When you connect to a database in InfoMaker without using a database profile, specifies when InfoMaker closes the connection. Select or clear the Keep Connection Open check box as follows:

• Select the check box (Default) Stays connected to the database during your session and closes the connection when you exit

• Clear the check box Opens the connection only when a painter requests it and closes the connection when you close a painter or finish compiling a script

Keep Connection Open in the online Help

Use Extended Attributes

Specifies whether InfoMaker should create and use the extended attribute system tables. Select or clear the Use Extended Attributes check box as follows:

• Select the check box (Default) Creates and uses the extended attribute system tables

• Clear the check box Does not create the extended attribute system tables

Use Extended Attributes in the online Help

Columns in Table Display

Specify the number of table columns to be displayed when InfoMaker displays a table graphically. The default is eight.

SQL Terminator Character

Specifies the SQL statement terminator character used in the ISQL view in the Database painter in InfoMaker.

The default terminator character is a semicolon (;). If you are creating stored procedures and triggers in the ISQL view of the database painter, change the terminator to a character that you do not expect to use in the stored procedure or trigger for your DBMS. A good choice is the backquote (`) character.

SQL Terminator Character in the online Help

Refresh Table List

Specify how frequently you want the table list to be refreshed from the database. The default is 30 minutes.