Subject Re: [firebird-support] compound FK fails
Author Martijn Tonies
> The sequence was
>
> - open db workbench to database
> - open script editor
> - run complete script, with commits between each ddl
> - get error

Did you uncheck the option in the Preferences?

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

> On 04/03/2008, Martijn Tonies <m.tonies@...> wrote:
> >
> > > > 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.