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)
There´s a better life... Just it´s more expensive!
Cristóbal Manrique M.