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