Fidel,

F> To be honest, execute blocks are, just like you said, useful to test
F> some code. I don't really see any benefit on using execute blocks over
F> a stored procedure, except when I want to test some code and I don't
F> really want to create a stored procedure for that.

IMHO execute block is to a stored procedure what a select statement
is to a view. Useful every time you need to dynamically build it.

Ciao
--
Nando Dessena
======================================================
I support Firebird, I am a Firebird Foundation member!
Join today at http://www.firebirdsql.org/ff/foundation
======================================================