> At 09:07 PM 1/11/2007, you wrote:
> >Woody wrote:
> >> If you want to see something really scary, try this one:
> >>
> >> select cast(coalesce(rdb$security_class, '') as varchar(80)), '1'
> >> from rdb$database
> >> group by 2, 1
> >>
> >> WARNING: So far, this locks up IBOConsole (and my PC) every time I try

it.

> >
> >No problems in FlameRobin.
>
> In IB_SQL it just keeps fetching ad infinitum (tho' fortunately IB_SQL

lets you stop a cursor from fetching).

?

Works fine in Database Workbench that uses IBO.

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