Location

Applies to:

Description

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

Remarks

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 Pervasive.SQL Programmer's Guide.

Example

'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" 
'Open the file 
stat = Customers.Open 

See Also:

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