Excellent, I understand now.

Thank you very much.

Walter.

On Wed, May 18, 2011 at 3:16 AM, Thomas Steinmaurer <ts@...>wrote:

>
>
> > I am using Firebird 2.5
> >
> > My questions are:
> >
> > - When and why to use the instruction "execute block"?
> > - What is the advantage over a Stored Procedure?
> > - What can I do with an execute block and not with a store procedure?
>
> - Execute block is a client-side thing, which allows you to run PSQL
> code without creating a stored procedure first.
> - A stored procedure gets compiled at creation time and stored in the
> database. Execute block isn't stored in the database and compilation
> happens each time the execute block is called.
> - A stored procedure is "visible" to all connections. Execute block isn't.
> - Only the owner of a stored procedure can alter it. Everybody can run
> an execute block statement
>
> Ah well, just some points out of my mind. ;-)
>
> --
> With regards,
>
> Thomas Steinmaurer
> Upscene Productions
> http://www.upscene.com
> http://blog.upscene.com/thomas/
>
> Download LogManager Series, FB TraceManager today!
> Continuous Database Monitoring Solutions supporting
> Firebird, InterBase, Advantage Database, MS SQL Server
> and NexusDB!
>
>
>


[Non-text portions of this message have been removed]