Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Is a table exist in a database?
Message
From
16/08/2000 04:26:57
 
 
To
16/08/2000 04:17:48
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00405358
Message ID:
00405377
Views:
12
>Oh.. Yes.
>You can cath this error and go ahead.. like
>lnError = 0
>lcOldError = "ON ERROR "+ON("ERROR")
>ON ERROR lnError = ERROR()
>DBSETPROP("table","TABLE","Path")
>IF lnError=1652
>&& Not part of database
>ENDIF
>&lcOldError
>
>I think it will works
>
>>>You can use DBGETPROP("tablename","TABLE","path"). Check return value to empty.
>>>Also see HELP on DBGETPROP() function
>>>Denis
>>>
>>>>How to know if a table allready exist in a database?
>>>>Thanks.
>>Hi Denis,
>>Thanks bu i wantend recieve a error message when the table isnt in the database.Is that possible?
Thanks Denis,
Fine trick.
Previous
Reply
Map
View

Click here to load this message in the networking platform