Try using sys(3054) while you are playing with the select. Watch for things like
- set deleted on and no index on deleted() in your table
- expression that does not match your index

local jrush
=SYS(3054,11,"jrush")

select a.vendno,a.company,a.drno,a.rcno,a.purno,a.loctid,;
a.adddate,a.addtime,a.adduser,a.org_rcno,b.item,b.qtyrec,b.umfact,;
b.umeasur,b.cost,b.lineno,b.taxrate,b.qtyord,b.qtyrec2,;
b.disc,b.qtyopen;
from po_main a, po_detail b ;
where alltrim(a.purno) == Lcvalue and alltrim(a.rcno) == Lcvalue2 and ;
a.purno == b.purno and a.rcno == b.rcno AND b.qtyrec2 != 0 into cursor cur_temp

? jrush

hope this helps...


>Hi to all,
>
>how can change this select statement to become faster.
>please help
>
>thanks.
>
>select a.vendno,a.company,a.drno,a.rcno,a.purno,a.loctid,;
> a.adddate,a.addtime,a.adduser,a.org_rcno,b.item,b.qtyrec,b.umfact,;
> b.umeasur,b.cost,b.lineno,b.taxrate,b.qtyord,b.qtyrec2,;
> b.disc,b.qtyopen;
> from po_main a, po_detail b ;
> where alltrim(a.purno) == Lcvalue and alltrim(a.rcno) == Lcvalue2 and ;
> a.purno == b.purno and a.rcno == b.rcno AND b.qtyrec2 != 0 into cursor cur_temp
>
> select cur_temp
> go top
> scan
> insert into ictran01 (..,) values (cur_temp.,,,)
> select cur_temp
> endscan