Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Why these two commands will give different results
Message
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Environment versions
Visual FoxPro:
VFP 8 SP1
OS:
Windows XP
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01174441
Message ID:
01174683
Views:
9
>>>??????
>>>
>>>lcRate = EVL(laArr[1],0)		
>>>
>>>
>>>I am almost sure you mean:
>>>
>>>lcRate = NVL(laArr[1],0)
>>>
>>
>>No, I meant EVL. I found that the array is not created if my conditions don't match. AFAIK the behavior has changed in VFP9, but I'm running with 8.
>
>If the array is not created you will get an error. Try:
>
>CREATE CURSOR Test (Fld1 I)
>INSERT INTO test VALUES (1)
>SELECT SUM(Fld1) FROM Test INTO ARRAY aaa WHERE .f.
>? EVL(aaa[1],0)
>
Not if you do
local array aaa[1]

before select <g>
If it's not broken, fix it until it is.


My Blog
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform