MDAC 2.5 SDK - Visual FoxPro ODBC Driver

SET PATH Command

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.

Driver Remarks

If you issue SET PATH in a stored procedure, it will be ignored by the following functions and commands:

• Catalog functions such as SQLTables and SQLColumns will ignore the new path and continue to reference the path specified by the data source in SQLPrepare or SQLExecDirect.
  
  
• Commands such as SELECT, INSERT, UPDATE, DELETE, and CREATE TABLE will ignore the new path and continue to reference the path specified by the data source in SQLPrepare or SQLExecDirect.

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

ODBC Visual FoxPro Setup Dialog Box

SQLColumns

SQLDriverConnect

SQLTables