The sequence was

- open db workbench to database
- open script editor
- run complete script, with commits between each ddl
- get error

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.
>
> 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
>
>
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Visit http://www.firebirdsql.org and click the Resources item
> on the main (top) menu. Try Knowledgebase and FAQ links !
>
> Also search the knowledgebases at http://www.ibphoenix.com
>
> ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
>
> Yahoo! Groups Links
>
>
>
>