>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

Try

lnquery = sqlexec(posqlconn,[ select prodcode from tuserprod (WITH NOLOCK) where in_use='Y' and usergroup = ?pusergroup],'c_prodlist')

Also I didn't re-read this thread #1381607 but may be it would be useful.