>VFP 6.0 sp4.. How can I programmitically check a table to see if a field exists and then get the fieldtype,fieldwidth,precision property.
>
>TIA
>Rob

1)
llExists = FSIZE("myfield", "mytable")>0

2) (only if using dbc)
llExists = INDBC("mytable.myfield", "Field")

option 2) is especially good for determining if a field exists
before running a SQL statement containing that field, w/o having to open up the table first.