Check for existance of column in table

Plateforme Level Extreme

Abonnement

Profil corporatif

Produits & Services

Support

Légal

English

Check for existance of column in table

Message

23/02/2005 05:18:41

Borislav Borissov
Microcomplex
Sofia, Bulgarie

23/02/2005 05:07:30

Yh Yau
Ingenuity Microsystems Sdn Bhd
Kuala Lumpur, Malaisie

Information générale

Forum:

Visual FoxPro

Catégorie:

Codage, syntaxe et commandes

Titre:

Re: Check for existance of column in table

Divers

Thread ID:

00989527

Message ID:

00989531

Vues:

This message has been marked as the solution to the initial question of the thread.

>Dear all,
>How do I check whether a particular column exist in a table? Tried field() but I only know the name of the column and not the position.
>Thanks in advance.
>Yau

** Existing of Field
 TYPE("YourTable.YourField") # "U" && The field exists
 TYPE("YourTable.YourField") == "U" && The field does not exists

Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.

Répondre

Fil

Voir

Click here to load this message in the networking platform