>>>Hilmar,
>>>
>>>SELECT SQL known only
>>>
MAX() like a grouping function>>>
>>>Fabio
>>
>>Yes, that is clear to me now. But I had never tried this before, and before I experimented this morning, I thought VFP would be able to distinguish the two uses of MAX().
>
>I thought it too, that's why I happily said "SELECT max(0, cantidad)"
Yes, I would probably have said the same, if someone asked me a few days ago.
Saludos,
Hilmar.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)