Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
OLEDB Table Exist ?
Message
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00617027
Message ID:
00617063
Views:
16
>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.
Previous
Reply
Map
View

Click here to load this message in the networking platform