>
>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.
I've looked at Help on ALTER TABLE and I don't see if it requires exclusive access or not.
Also, does your code require to have the table opened? And why do we have INDBC(.. ) for the field? What good can the value return if it doesn't tell which table?
Thanks.
If it's not broken, fix it until it is.
My Blog