Sets the default database from which tables are accessed.

Syntax

SET DATABASE TO [<database name>]

<database name>

Specifies the name of the database you want to make the current database.

Description

SET DATABASE sets the current database, which defines the default location for tables accessed by dBL commands. Using this command, you can select from any databases previously opened with the OPEN DATABASE command. Databases are defined using the BDE Administrator.

When you issue the SET DATABASE TO command without a database, dBASE Plus restores operation to accessing tables in the current directory (or in the directory specified by SET PATH) instead of through a database.

OODML

Assign the appropriate Database object to the Query object’s database property.