Location

Sets or returns the drive, path, and file name of the PSQL file associated with this control.

At design time, the Location property defaults to the value of Table Location in the DDF definition of the file specified in the TableName property.

This property represents the operating system device, path, and file name of the database file associated with the control.

This property may contain a fully qualified path and file name, or a file name only. If it contains file name only, an Open method will attempt to open the file in the directory specified by the DdfPath property.

For more information on using the Location property, see the PSQL Programmer's Guide.

'Close the currently opened file

Customers.Close

'Set the location information

Customers.RefreshLocations = True

Customers.DdfPath = "v:\accounts"

'When we set the table name location will

'be set to the location

'specified in the ddf file if the

'current location is blank.

'If we want to use a different data file

'we need to explicitly specify it

'but this change will not be recorded in ddf file

'unless we call DdfModifyLocation

Customers.TableName = "customer002"

Customers.Location = "cust002.dat"

stat = Customers.Open

Affected by: DdfPath, TableName, RefreshLocations, HostAddress, HostConnect, AutoOpen, OnRemote