it all depends how you look at it. I switched from SQLServer/MSDE to Interbase
more then three years ago and ported multiple business apps to IB. Yes, it was a
bit different in the beging, and certain thing could not be done the 'mssql' way
but, ultimately I did get everything ported :-)

Raf

donjules2k wrote:

> In reply to my own question, i supose you could make a stored proc
> wich calls another stored proc. Hence the sub stored proc "acts" like
> a temp table. This might be use full for summing or grouping values
> but useless if you wanted the power of a true temp table, such as
> updating values.
>
> Jules
>
> --- In firebird-support@yahoogroups.com, "donjules2k" <giulio@g...> 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