can you do selectable stored procedures in mssql? No? Perhaps thats why you have
to resort to temp tables and cursors :-)



donjules2k wrote:

> I have just been looking further into the spec and it seems FB does
> not support temporary tables, or am I wrong?
>
> The main use i have for stored procs is doing multiple complex selects
> which may even return multiple recordsets. This can often invlove
> temprary tables, to up[date values or whatever else before the final
> return.
>
> Now am I being blind stupid or is there a way to do this in FB? At the
> moment, a stored proc in FB seems like a glorifed select statement.
>
> Anyway, thanks for all your help guys, I'm finally our of first gear!
>
> Jules
>
>
> --- In firebird-support@yahoogroups.com, "Martijn Tonies"
> <m.tonies@u...> wrote:
>
>>>take another look - IBExpert will actually create a select sp for
>
> you on
>
>>the
>>
>>>table. You just tick/untick the fields you want. But select * from
>
> table
>
>>>into :param1 is not as good as select field1, field2 etc
>>
>>IBExpert isn't the only tool ;-)
>>
>>With regards,
>>
>>Martijn Tonies
>>Database Workbench - developer tool for InterBase, Firebird, MySQL &
>
> MS SQL
>
>>Server.
>>Upscene Productions
>>http://www.upscene.com
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>

--
Rafael Szuminski
Email:raf@...
Phone:(949)939 - 2458
www.BDCSoftware.com