>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.
Insanity: Doing the same thing over and over and expecting different results.