Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Columns
Message
 
 
To
28/10/2002 15:22:20
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00716154
Message ID:
00716178
Views:
15
You can check if field exists in the table with one-liner.
FldExist = (TYPE("MyTable.mycol") <> "U")
>
>FldsCnt = AFIELDS (aFlds, "MyTable")
>FldExist = .F.
>
>FOR I = 1 TO FldsCnt
>   IF aFlds [I, 1] == "MYCOL"
>      FldExist = .T.
>      EXIT
>   ENDIF
>ENDFOR
>
--sb--
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform