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