>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)
Have you tried something like:
MyVar = 0
SELECT MyTable
CALCULATE MAX( MyField ) TO MyVar FOR ( code = MyCode AND MyFilterCondition )
Bill
William A. Caton III
Software Engineer
MAXIMUS
Atlanta, Ga.