>>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')

That is so cool! It's perfect. But you got me! I haven't been able to interpret the line. It looks like a directive because of the #, but I can't find anything that looks like what you've got. Could you please explain how it works? Slowly for thick heads like me, please.

Pete