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