>Hi all,
> Is there a simple way to determine if a field name exists in a table? There may be 40 or 50 fields in a given table, and using 10 to 15 tables from the command window sometimes leaves us to forget if a table had those particular fields added.
> I thought using AFIELDS() and then ASCAN(), but isn't there a little better way than scanning the entire table structure array? I saw the aColScan() FUNCTION in 'Hacker's Guide 6' but that seems like a lot to do just to see if a particular field name exists, plus LPARAMETER doesn't exist in FPW. Something like a reverse FIELD() function that returned T or F would be real nice.
> Any ideas?
>Pete

llFieldExists = (type('mytable.myfield')#'U')