>>>??????
>>>
>>>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