Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Check for field name in table
Message
From
20/01/2011 01:47:41
 
 
To
20/01/2011 01:28:25
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01496634
Message ID:
01496639
Views:
94
sorry - i found solution in previous forum reply. I think Tore's help.
cfile='c:\db\past.DBF' 
if 'thh05'$cfile = .F.
k
etc
>what code could i use to verify if a field name is present in a table.
>
>Alter Table c:\db\past.DBF Rename Column thh05 To thh11
>
>
>this works fine however if the program is repeated thh05 is no longer present and an error message appears.
>
>i need an 'if' command to check for thh05
>
>thanks
>k
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform