> > Agreed, but without the proper error message, it's hard to tell :-)
> >
> > My first guess would be having multiple connections. Each SQL/Script

Editor

> > in Database Workbench can optionally open a secondary connection for
> > threaded querying. This can be turned OFF in the Preferences. If the
> > SQL/Script Editor opens a secondary connection, the script will fail in

Fb <

> > 2.0
> >
>
> It wasn't that, I carefully made sure that I only had one window open,
> I tried it both using the GUI and the sql editor. I did make a mistake
> earlier in that this is fb 2.0 not 1.5

The additional SQL editor can be the cause of a secondary connection.

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