Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Verify if a field already exists in a table
Message
 
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 9 SP1
OS:
Windows XP SP2
Network:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01238247
Message ID:
01244221
Views:
26
>>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
>
>You may want to check AFIELDS() function and ASCAN or you can simply put your ALTER TABLE command in try/catch block (but in this case you would need to open table exclusively).

Well, it was not a good suggestion, as it turned out. Use FIELD() function instead.
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform