>>
select TOP 1000 unemp_ins_pct from payroll_tbl ;
>> where unemp_ins_pct # 0 ;
>> into array a__gen40 ;
>> order by payroll_tbl.id DESC
>>
>
>Thanks Sergey. Haven't use foxpro for a while, into .NET now.
This solution will work for most back ends as long as they support TOP clause in a query.
--sb--