Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Check to see if a table exists without knowing its locat
Message
 
To
04/05/2005 15:41:45
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP SP2
Network:
Windows 2000 Server
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01010987
Message ID:
01011029
Views:
27
This message has been marked as a message which has helped to the initial question of the thread.
Tracy,

Another less elegant alternative is to try and catch
? getTablePath('dbWorkFiles', 'myTable')

function getTablePath(tcDataBase, tcTable)
local lcPath

try
   use (tcDataBase + '!' + tcTable) alias someAlias in 0 again shared
   lcPath = justpath(dbf())
   use in select('SomeAlias')
catch
   lcPath = null
endtry
return lcPath
"The five senses obstruct or deform the apprehension of reality."
Jorge L. Borges?

"Premature optimization is the root of all evil in programming."
Donald Knuth, repeating C. A. R. Hoare

"To die for a religion is easier than to live it absolutely"
Jorge L. Borges
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform