Hi Thys,
>> I saw a previous post asking for advice how to create a browse on a queue. The responses pointed to using a memory table and not a queue.
Correct, global queues are not thread-safe, and local queues don't exist for long enough to be useful.
>> I have a similar request, but my queue is created from rows that SQL stored procs returns.
Template work on fixed structures, not variable structures. So if you are creating variable structures at runtime, and you want to use a template, then you need to move that data into a known fixed structure.
>> The only way that I think it will work, is to create a temp table to populate the results into and then load it in the browse via a dct table.
Correct, that's the easiest way.
>> Because it's multi-user I'll have to be careful to have distinct temp table names.
It's a lot simpler to add a SessionID field to the memory table, and then just filter on that for the browse.
Cheers
Bruce