Subject | Re: [Firebird-Architect] Re: Indexed Views |
---|---|
Author | Vlad Horsun |
Post date | 2004-12-22T15:34:01Z |
> > > well, this gives some weight to a proposal to throw exception onYes, exactly.
> > > SELECT from procedures without SUSPEND -- for I have made such mistake
> > > more than once.
> >
> > EXECUTE BLOCK with outputs semantically fully equal to
> > SELECT * FROM stored procedure
> And will silently return empty "resultset" if I forget to add SUSPEND?
> > If you wish, you may read "doc\sql.extensions\README.execute_block"Good ;)
> > which is available near the year :
> >
> > Since EXECUTE BLOCK is generated from client-side it's not needs
> > to have default parameters
> Thanks, now I understand.
> Actually, I was fooled by similiarity betweenYes
> CREATE PROCEDURE p (x INTEGER = 1)
> and
> EXECUTE BLOCK (x INTEGER = ?)
> They are, of course, totally different.
Regards,
Vlad