Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Table exists in SQL Server
Message
 
À
08/10/2002 10:58:10
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00708763
Message ID:
00708807
Vues:
8
>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
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform