>>>>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
>
>
>*all the same
>llFieldExists = (type('mytable.myfield')<>'U')
>llFieldExists = (type('mytable.myfield')#'U')
>llFieldExists = !(type('mytable.myfield')='U')
>
># = <> = ! = NOT

Finally figured it ou on my own. This is the first time I've seen anyone use the # symbol. Boy, like I said, Thick Headed. Thanks for the ti[ and the explanation.
Pete