MDAC 2.5 SDK - Visual FoxPro ODBC Driver
Specifies a path for file searches. For driver-specific information, see Driver Remarks.
Syntax
SET PATH TO [Path]
Arguments
TO [Path]
Specifies the directories you want Visual FoxPro to search. Use commas or semicolons to separate the directories.
Remarks
SET PATH allows you to specify search paths for other Visual FoxPro programs that can be called within stored procedures. SET PATH will not change the path of the data source that you've specified for the connection.
Issue SET PATH TO without Path to restore the path to the default directory or folder.
If you issue SET PATH in a stored procedure, it will be ignored by the following functions and commands:
If you issue SET PATH in a stored procedure and don't subsequently set the path back to its original state, other connections to the database will use the new path (because SET PATH is not scoped to data sessions).
If you want to create, select, or update tables in a directory other than that specified by the data source, specify the full path of the file with your command.
See Also