>>>>??????
>>>>
>>>>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>
Yep,
But I didn't saw this :-)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.
