>>>Fabio,
>>>
>>>There's nothing to document. UDF in a query cannot make any assumption about what the current work area is or what current record pointer is. It's your problem if you use UDF this way not VFP.
>>
>>Sergey,
>>While I agree that Fabio may have been too quick with calling this a bug, your argument is not valid here. The record number and workarea are not used in the expression (MOD(A,1000)#0 OR THERMO(A)).
>
>Peter,
>
>I was refering to Fabio's post that includes following code
>PROCEDURE THERMO(vValue)
> ? "recno()=",RECNO(),"A=",vValue
As you can see it does reference current work area and RECNO()
Yes, I know, and recno() indeed is either okay or not. (It is more or less promissed by vfp to be okay if the select-sql uses only one table.) But that is not the problem that Fabio and I are refering to. What is not documented is that the left-to-right evaluation of expressions in a SQL's WHERE expression is not, or not always, done as it is done in VFP. And Fabio also thinks that behavior changed between vfp7 and vfp9. This latter statement I personally doubt.
Groet,
Peter de Valença
Constructive frustration is the breeding ground of genius.
If there’s no willingness to moderate for the sake of good debate, then I have no willingness to debate at all.
Let's develop superb standards that will end the holy wars.
"There are three types of people: Alphas and Betas", said the beta decisively.
If you find this message rude or offensive or stupid, please take a step away from the keyboard and try to think calmly about an eventual a possible alternative explanation of my message.
