>>How can I verify if a field already exists in a table?...
>>Need to create it if doens´t....
>
>If it does not exist, add it
>

>If Fsize("MyField") = 0
>   Alter Table MyTable Add Column MyField C(10)
>EndIf
>

>
>Another:
>
>If it does exist, drop it
>

>If Fsize("MyField") > 0
>   Alter Table MyTable Drop Column MyField
>EndIf
>

>Exclusive of course.


But make sure SET COMPATIBLE is OFF; otherwise FSIZE() has an entirely different meaning.

Tamar