Subject Return rows from procedure :: was Idea for a new field type for FB 2,0 or IB 7?
Author Helen Borrie
At 08:42 PM 21-11-01 +0100, Paulo Gaspar wrote:

>What I really miss is being able to return result sets ( = a set of
>rows = the result of some SELECT) from inside a Stored Proc.
>This is one of the few things I miss from M$ SQLServer!

Extraordinary! one of the many things I hated about SQLServer was the contortions one has to go through to get row sets back from a SP! Not to mention the _further_ contortions to undo the work when a user error breaks the logical task.

Have you never done a
FOR...SELECT...INTO...DO...SUSPEND style of procedure in IB?

When you SELECT * from myproc(:param1, param2), the procedure does all its stuff and then returns the rows to play with. Everything stays inside the same transaction context and you can roll the whole lot back, if it comes to that...try to get that degree of ACID from SQLServer.


All for Open and Open for All
InterBase Developer Initiative ยท