Configuration topics > BDE configuration settings > Drivers settings

To configure the way Paradox tables are created, sorted, and handled, choose Paradox as the driver name on the Configuration page of the BDE Administrator or create or select a STANDARD alias on the Databases page that uses Paradox as the Default Driver.

To change a setting, highlight the desired configuration parameter. Delete the old value and enter a new one in the appropriate text box. You can only change parameters WITHOUT bold labels.

In the following table, Parameters lists all tracked parameters for the selected driver type, and their current settings. When the driver is first installed, all values are set to their defaults.

Description briefly notes the purpose of the highlighted parameter.

Parameter

Description

NET DIR

The directory location of the Paradox network control file PDOXUSRS.NET. The active NET DIR parameter is stored in the Paradox section of the BDE configuration file and has precedence over any other NET DIR parameters that may be stored in older 16-bit configuration files, or in the System Init section of the current configuration file, or in the Registry. These other NET DIR entries will have no effect. To access a Paradox table on a network drive, the active NETDIR parameter in the Paradox section of the BDE configuration file must point to a network drive.

VERSION

Internal version number of the Paradox driver.

TYPE

Type of server to which this driver helps you connect. Can be SERVER (SQL server) or FILE (standard, file-based server).

LANGDRIVER

Language driver used to determine table sort order and character set. [available drivers].
US default: 'ascii' ANSI (DBWINUS0)

BLOCK SIZE

Size of disk blocks used to store Paradox table records, in multiples of 1024 bytes. Valid settings depend on the table format:

Level 5 & 7 1024, 2048, 4096, 16384, and 32768

Level 3 & 4 1024, 2048, and 4096

Default: 2048

FILL FACTOR

Percentage of current disk block which must be filled before Paradox will allocate another disk block for index files. Can be any integer ranging from 1 to 100. Default: 95

Note:

Smaller values offer better performance but increase the size of indexes. Larger values give smaller index files but increase the time needed to create an index.

LEVEL

Type of table format used to create temporary Paradox tables.

Level 7 Paradox for Windows 32-bit tables

Level 5 Paradox 5.0 tables

Level 4 STANDARD table format introduced in Paradox 4.0

Level 3 Compatible table format used by Paradox 3.5 and earlier versions.

Default Level 4.

To use Blob fields, secondary indexes, and strict referential integrity, specify either Paradox level 4 or Paradox level 5 tables. You will probably want to use the lowest level possible in order to maximize backward compatibility. Choose Level 7 only If you need the advanced indexing features supported by that table format.

STRICTINTEGRTY

Specifies whether Paradox tables can be modified using applications that do not support referential integrity (such as, Paradox 4.0). For example, if TRUE you will be unable to change a table with referential integrity using Paradox 4.0; if FALSE, you can change the table, but you risk the integrity of your data. Default: TRUE.

Paradox driver settings

Paradox driver settings