If you do a DBF() on a view or a cursor that isn't actually a disk based table, you'll get a filename that ends in '.tmp' rather than '.dbf'. Does that help at all?

>If I have a database: dbWorkFiles
>
>and I want to determine if one of its tables physically exist I would typically store a common path to the data directory to a variable like 'ddir' and then do:
>
>IF FILE (ddir+'mytable.dbf')
>
>However, if I do not know exactly where the tables are located - lets say I open them with:
>
>use dbWorkFiles!mytable
>
>then how can I check to see if the table exists or not if I do not know where they are located? Is that possible? It could be a part of the database but not physically exist...