I'm just using a normal SPT,
something like :-
lnquery = sqlexec(posqlconn,[ select prodcode from tuserprod where in_use='Y' and usergroup = ?pusergroup],'c_prodlist')
I query it into a cursor. The cursor is used to do a grid search.

Yau