Re: can procedure return a recordset?

Try ref cursors. This is what we use in powerbuilder and crystal reports to deal with record sets.

On Sun, 07 Nov 1999 13:47:25 GMT, wy_at_fudan.edu wrote:

>How to write a procedure to return a recordset?
>such as P1('AA')
>= select * from t1 where f1 = 'AA';
>because I want to make a report and its data need to be calcuated.
>If the data is prepared in server and return to client one time,it
>can save a lot of time.
>and In Delphi I can use a procedure to link a report easily.
>(by the way,in Sqlserver it can easily realise.)
>
>Any Suggestings are helpful!
>Thanks in advance.
>
>YangWang.
>
>
>Sent via Deja.com http://www.deja.com/
>Before you buy.
Received on Mon Nov 08 1999 - 01:11:00 CST