how to pass resultset from appserver to client

[saurabh]

Hello
I am new to progress.I want to know that how can get the sql results that i have retrieved from the procedure running on appserver, to the procedure running on the client. In other words my procedure at appserver have to pass the parameter of resultset to my procedure running on client.
Pls treat it as urgent as I am stuck.

Thanx in advance.
Saurabh Sharma

 

[jongpau]

Use a temp-table (either static or dynamic) as an output parameter in your appserver procedure you can transfer a whole bunch of records back to the client (which needs that parameter as well of course).