Customize settings for the dBASE Plus desktop environment. The Table page lets you specify how tables, records, and fields are opened, compared, excluded, saved, searched, and locked.

Dialog box options

 

Multiuser

Set options for tables with more than one user.

Lock If checked, dBASE Plus attempts to lock a shared table during execution of commands that read the table but do not change its data. The default is on (checked).

Exclusive If checked, dBASE Plus opens tables and their associated index and memo files for exclusive use. If not checked, they are opened for shared use. The default is off (unchecked / shared use).

Refresh Set how often (in seconds) the workstation screen is refreshed with table information from the server. The default is 0, meaning the screen is not updated.

Reprocess Specify the number of times dBASE Plus tries to lock a file or one or more records before generating an error or returning .F. (false). The default is 0, meaning dBASE Plus does not try to lock a file or one or more records more than once.

Default table types

Set the default table type used by commands that open or create a table. Choose either the dBASE (DBF) or the Paradox (DB) table file format. Default: dBASE.

System tables

Specify whether the Navigator displays SQL client/server system tables. If checked, system tables are displayed. If unchecked, only user tables are displayed. The default is off (unchecked).

Block sizes

Set the number of bytes allocated when creating index files and memo fields. Using these values, you can affect the size and efficiency of these files.

Index block Specify the size of blocks in which dBASE Plus stores .MDX index files on disk to improve the performance and efficiency of indexes. The default is 1. The size in bytes is the number you specify multiplied by 512. The minimum block size is 1024 bytes.

Memo block Specify the default block size of new memo field (.DBT) files. The size in bytes is the number you specify multiplied by 64. The default is 8, or 512 bytes. If your table will have a small amount of information in each memo field, use a smaller number.

Other

Set other options for working with tables.

AutoNullFields Determines how dBASE Plus handles empty fields. When checked (default), empty fields assume a null value (the absence of value). When unchecked, numeric fields (long, float, etc.) are assigned a value of zero, logical fields a value of "false", and character fields are filled with spaces.

Autosave If checked, data is written to disk each time a record is changed or added. The default is off (unchecked).

Exact Specify how character strings are compared. If checked, two character strings are equal when they are identical and are the same length. If unchecked, two character strings are equal if the characters in one string match the beginning characters in the other string. The default is off (unchecked).

Encryption Specify whether table encryption is copied when an encrypted table is copied. If checked, a table created by copying an encrypted table is also encrypted. If unchecked, a table created by copying an encrypted table does not contain encryption. The default is on (checked). For information on encrypting tables, see File|Database Administration or Table Security.

Deleted Specify whether dBASE Plus displays or hides records marked for deletion in a table. If unchecked, all records appear in a table. If checked, records marked for deletion are excluded from processing by subsequent commands. The default is on (checked).

Near Specify where to move the record pointer if a FIND, SEEK, or SEEK( ) operation fails to find an exact match. If checked, dBASE Plus finds the record nearest the search value. The default is off (unchecked).

How to get there: Choose Properties|Desktop Properties. Click the Table tab.