>>Using ALTER TABLE I know, but if the table is not in a database how do I check if the column exists before I DROP or ADD it? In a database I would use INDBC() but not sure how to do the same on free tables. Thanks!
>>
>Hi Renoir,
>
>The TYPE() function can help you
IF TYPE("mytable.myfield") <> "U"
> * Filed exists
>ELSE
>...
>ENDIF
Sergey,
As usual that was exactly what I was looking for. I wasn't aware I could use it that way. I've always used it primarily with variables or the values of a field in a record.
Thanks! Renoir