Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Table exists in SQL Server
Message
 
To
08/10/2002 10:58:10
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00708763
Message ID:
00708807
Views:
9
>I currently check for the existence of a specific file in a specific location to determine if a "module" is installed.
>
>RETURN file(_screen.mvApplication.DataDirectory + "PEOPTION.DBF")
>
>How can I accomplish the same thing in SQL Server?

You can used the SQLTABLES() function in VFP to return a list of all user tables. You'd simply have to use a locate statement to see if it exists. See documentation for details.
George

Ubi caritas et amor, deus ibi est
Previous
Reply
Map
View

Click here to load this message in the networking platform