Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Checking Table Structures
Message
From
02/03/2009 10:27:09
 
 
To
02/03/2009 10:24:39
Jay Johengen
Altamahaw-Ossipee, North Carolina, United States
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Miscellaneous
Thread ID:
01384954
Message ID:
01384956
Views:
68
>I have these fields that should be in a table. I want to cycle through them and check if they are. If they are not, then I want to add them. What is the best way to do that?
>
>
>			(	status1 L, ;
>				status2 L, ;
>				status3 L, ;
>				status4 L, ;
>				status5 L, ;
>				status6 L, ;
>				status7 L, ;
>				status8 L, ;
>				status9 L, ;
>				status10 L, ;
>				status11 L, ;
>				status12 L, ;
>				status13 L, ;
>				Assigned L, ;
>				AssignedTo V(80), ;
>				AnyKeys L, ;
>				KeyWords M, ;
>				LastTable M, ;
>				LastIssue I )
>
You may use TYPE or VARTYPE to check if field exists, or you may scan through AFIELDS() array; and if field is not there then you use ALTER TABLE to add it.
Edward Pikman
Independent Consultant
Previous
Reply
Map
View

Click here to load this message in the networking platform