>>??????
>>
>>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)
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.