Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
Is a table exist in a database?
Message
De
16/08/2000 04:26:57
 
 
À
16/08/2000 04:17:48
Information générale
Forum:
Visual FoxPro
Catégorie:
Base de données, Tables, Vues, Index et syntaxe SQL
Divers
Thread ID:
00405358
Message ID:
00405377
Vues:
13
>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.
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform