>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
Where is WHERE condition in this SQL?
If it's not broken, fix it until it is.
My Blog