Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
OLEDB Table Exist ?
Message
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00617027
Message ID:
00617063
Vues:
17
>In some VBScript code, I make an OLEDB connection to a database, and then drop a table and re-create it. This works fine if there already is a table, but if there isn't, I get
Microsoft OLE DB Provider for Visual FoxPro: Invalid path or file name.
. What kind of command can I use to trap for this? I think I can use DBGetProp() but I am not sure.....

With ADOX you can traverse the Tables collection of the catalog object. (that has been opened with a connection to your DBC) Checking the Name property of each table can help you check if the table exists.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform