| Subject | Return rows from procedure :: was Idea for a new field type for FB 2,0 or IB 7? |
|---|---|
| Author | Helen Borrie |
| Post date | 2001-11-22T00:17:40Z |
At 08:42 PM 21-11-01 +0100, Paulo Gaspar wrote:
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.
Helen
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________
>What I really miss is being able to return result sets ( = a set ofExtraordinary! 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.
>rows = the result of some SELECT) from inside a Stored Proc.
>
>This is one of the few things I miss from M$ SQLServer!
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.
Helen
All for Open and Open for All
InterBase Developer Initiative ยท http://www.interbase2000.org
_______________________________________________________