Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Verify if a field already exists in a table
Message
From
06/07/2007 12:39:34
Fred Taylor
Phoenix, Arizona, United States
 
 
To
06/07/2007 12:27:56
Carlos Burgos
Www.Empagran.Com
Los Angeles, California, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Re: Verify if a field already exists in a table
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01238247
Message ID:
01238257
Views:
19
>Hi everyone..
>
>How can I verify if a field already exists in a table?...
>Need to create it if doens´t....
>
>Thanks in advance
>Carlos Burgos
IF TYPE("yourtable.fieldname")<>"U"
  * exists
ELSE
  * you need to add it
ENDIF
Fred
Microsoft Visual FoxPro MVP

foxcentral.net
Previous
Reply
Map
View

Click here to load this message in the networking platform