General information
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Network:
Windows 2000 Server
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...
Previous
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only