|Subject||Re: Re: [Firebird-Architect] RFC: Please unify stored|
> > > > > If SP has outputs - do SELECT else do EXECUTE. What is wrongIf you know what the problem is, why do you come up with
> > it ?
> > > >
> > > >
> > > > A procedure can have output parameters and produce output
> > > > without having a SUSPEND. Such a procedure returns results
> > > > when called with EXECUTE and returns NO ROWS when called
> > > > with SELECT.
> > >
> > > This is develore's mistake - write procedure without SUSPEND
> > > and call it with SELECT. This "problem" is like a "problem" with
> > > FOR SELECT INTO when variable not change it's value if resultset
> > > is empty
> > That is NOT the problem that's being discussed.
> > The problem is "how to know if you should use SELECT or EXECUTE
> > if you don't know anything about the procedure".
> Martijn, dear, can you don't repeat it any more, please ?
> At least for me...
useless answers then?
Database Workbench - developer tool for InterBase, Firebird, MySQL & MS SQL