Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Calculate max() failed
Message
From
20/08/1999 08:59:45
 
 
To
19/08/1999 14:49:42
General information
Forum:
Visual FoxPro
Category:
Other
Miscellaneous
Thread ID:
00255384
Message ID:
00255807
Views:
10
Yes, it worked; but the point here is that I don´t want to go through all the table when I can just check a few records.
More than it, VFP MUST have worked fine, we're not supossed to be investigating wether an instruccion works or not before we use it. For the very first time, VFP has deceived me.

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

Click here to load this message in the networking platform