Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
EVL and NVL
Message
From
19/05/2004 06:36:17
 
 
To
18/05/2004 20:46:44
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Miscellaneous
Thread ID:
00905138
Message ID:
00905194
Views:
18

<snip>
Hey MS - Any plans to change of "fix" this.


I agree with you,
but it is a Function,
and therefore it is necessary to estimate all the parameters before executing of the code.

Of course VFPT can crack this standard schema,
but i think that this event non occur on the future VFP releases.

EVL() and NVL() are usefull with a :
EVL(EXPRESSION,surrogateCostant or Variable)
NVL(EXPRESSION,surrogateCostant or Variable)
but if second parameter is slow to evaluate, use IIF(),
IIF(ISNULL(EXPRESSION),surrogateCostant or Variable,EXPRESSION)
but if EXPRESSION is slow to evalute or worse, it is not deterministic,
you must to please you of:
varExp=EXPRESSION
IIF(ISNULL(m.varExp),surrogateCostant or Variable,m.varExp)
Fabio
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform