Hi,

> > Works fine in Database Workbench that uses IBO.
>
> Have you tried navigating the grid to the end of the result set? It's
> probably 'fetching on demand' Execute it in ISQL and you'll see it's an
> 'infinitum' set

Perhaps I'm using the wrong Firebird version? I'm using 2.1.

The resultset is a single row, so it stops fetching.

Yep, I just tried Firebird 1.5 -> that keeps fetching.

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