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