Not sure if any of the replies are resolving your issue yet but a long winded but definite way of achieving your goal would be to load the data values into a incrementing global i.e. set ^SQLWK($i(SQLWKvariable))=SQL values. You can then run down the global instead of your query result set.
Thanks for your very detailed response. Coudl I just confirm that you applied this enhancement to your Cache80.conf file please?
Thanks Vic and Eric,
I think I will call support tomorrow if I cant work out Dmitriy's solution.
Log in or create a new account to continue