Setting database preferences

The way you set connection-related database preferences in DataWindow Designer varies, as summarized in the following table.

**Table 7-1: Database preferences and where they can be set**
Database preference	Set in development environment by editing
AutoCommit	Database Profile Setup dialog box for your connection
Lock	Database Profile Setup dialog box for your connection
Shared Database Profiles	Database Preferences property sheet
Connect DB at Startup	Database Preferences property sheet
Connect to Default Profile	Database Preferences property sheet
Read Only	Database Preferences property sheet
Keep Connection Open	Database Preferences property sheet
Use Extended Attributes	Database Preferences property sheet
SQL Terminator Character	Database Preferences property sheet

The following sections give the steps for setting database preferences in the development environment.

For information about using a specific database preference, see its description in the online Help.