>I guess this would work too:
>
>
>IF DBUSED('dbProfiler')
> SET DATABASE to dbprofiler
> IF !FILE(LEFT(DBC(),RAT("\",DBC()))+"MYTABLE.DBF")
> *--Do whatever
> ELSE
>
>
>then I don't need to know where it is physically located or set the path but only ensure the dbc is open (which is done earlier in the app)
How about using JUSTPATH()?
IF !FILE(JUSTPATH(DBC())+"\"+"MYTABLE.DBF")