I used this:
select mytable
set order to mycode
seek (mycode)
myvar = ""
Calculate max(myfield) to myvar rest while code = mycode for myFilterCondition

It works fine ONLY if there are matching records to myFilterCondition.

If no records within the scope match myFilterCondition, myvar returns a value from myfield on the next record out of the scope (this is, where code # mycode).

I expected myvar to be blank when no matching records, even if it wasn´t blank before the calculation and much more if it was blanked as shown upthere.

Is this a bug of vfp?. Does this work as I expected in other versions of Vfp? (I´m running VFP 6.0 version number 06.00.8167.00)