>Hi everyone..
>
>How can I verify if a field already exists in a table?...
>Need to create it if doens´t....
>
>Thanks in advance
>Carlos Burgos
Carlos, here you go:
llFoundIt = .F.
lnFC = FCOUNT()
For I = 1 to lnFC
If FIELD( I ) = lcFieldILookFor
llFoundIt = .T.
EndIf
EndFor
If not llFoundIt
... Code to create field in table
EndIf
Terry
- Whoever said that women are the weaker sex never tried to wrest the bedclothes off one in the middle of the night
- Worry is the interest you pay, in advance, for a loan that you may never need to take out.