Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Check for existance of column in table
Message
 
To
23/02/2005 05:07:30
Yh Yau
Ingenuity Microsystems Sdn Bhd
Kuala Lumpur, Malaysia
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Check for existance of column in table
Miscellaneous
Thread ID:
00989527
Message ID:
00989531
Views:
34
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.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform