Thanks for the info Helen

On Fri, 29 Oct 2004 23:01:48 +1000, Helen Borrie <helebor@...>
wrote:

> Stored procedures are compiled and, in fact, can't be used unless they
> are. You can use SPs to perform operations and extractions that would be
> impossible, or slow, using the regular SQL statement syntaxes. Firebird
> also has triggers, another form of procedural module, that are bound to
> tables and will run automatically when the table changes its state. They
> are also precompiled.

Could you possibly give me an example of an SP that would be impossible or
slow with regular sql?

--
Kind regards

Peter Sanders