>Tore,
>In essence, it is like :-
>sele top 50 prodcode, proddesc ;
>from tstokmast ;
>order by 1,2 ;
>into cursor c_prodlist
>
>I'm using macro substitution for prodcode and proddesc as its a parameter passed from a base form. (&firstfield where firstfield value is "prodcode").
>I just typed this into the command window and the result is no better.
>Yau

Did you have any indexes of that table?
If you have try to add some WHERE clasue that match some of orders and always returns .t.