Subject Re: [IBO] Firebird 2.0: Bug when re-using a TIBOQuery component
Author Martijn Tonies
Hello Jason,

> Ok, I think I figured out the crux of the problem.
> This may not be how I chose to fix this in the next release but please
> this adjustment to the GetIsSelectSQL method and tell me how it works for
> you.
> This is around line 21,536:
> function TIB_Statement.GetIsSelectSQL: boolean;
> begin
> Result := ( StatementType in [stSelect, stSelectForUpdate] ) or
> SQLIsExecuteBlock;
> end;
> 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?

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