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