>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
Is your data table built into the .EXE? If it is, that's the one it will find, no matter what.