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

make

> 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
http://www.upscene.com
My thoughts:
http://blog.upscene.com/martijn/
Database development questions? Check the forum!
http://www.databasedevelopmentforum.com