Subject Re: [IBO] Firebird 2.0: Bug when re-using a TIBOQuery component
Author Martijn Tonies
> > > Hope this helps,
> >
> > This seems to fix the problem for now.
> >
> > One more question regarding EXECUTE BLOCK though, if it
> > has a RETURNS clause, are these always to be returned as
> > fields (select-able?), or also as output parameters?
> In IBO native fields and output parameters are one and the same in the
> Fields array.
> In TIBODataset they likely will be considered output fields as well though
> in my opinion they should be considered the same as if it was a stored
> procedure because I anticipate that it is more like an EXECUTE PROCEDURE
> call than a SELECT statement. Although, due to the API telling me that it
> is a select statement does seem to conflict with the common sense of it.
> Are you using EXECUTE BLOCK as a select for multiple records or as an
> execute procedure?

I've tried both, with and without SUSPEND, they both seem to return
a resultset. It's fine by me though, given that it just works ;-)

Martijn Tonies
Database Workbench - tool for InterBase, Firebird, MySQL, NexusDB, Oracle &
MS SQL Server
Upscene Productions
My thoughts:
Database development questions? Check the forum!