FoxPro always used the SET("PATH") command when your file is not in the default directory.
Try this.
? FULLPATH("CLIENT.DBF")
==> (return the location of your file)
>I could have sworn FILE() always worked O.K. but when I have a path set, FILE() finds a file in the path even when I specified a different one. For instance:
>
>Where clients.dbf exists in c:\
\data, default is c:\ and the data directory is in the path:
>
>file('c:\clients.dbf') gives .T. (c:\clients.dbf does not exist)
>file('d:\clients.dbf') gives .T. (d:\clients.dbf does not exist)
>file('c:\chr\clients.dbf') gives .F. (which is right - the chr subdirectory exists)
>file('c:\zzz\clients.dbf') gives .F. (which is right - the zzz subdirectory does not exist)
>file('clients.dbf') gives .T. (although the data subdirectory is in the path but is not the current directory)
>
>Is this normal?
>
>This behaviour extends to the USE command I.E. USE c:\clients.dbf opens the clients.dbf in the DATA subdirectory
>
>Any comments would be appreciated. In 10 year of xbase, I have never learned this???
>
>TIA
>Charles Richard