Ugh! I've seperated the statements and am now running them through
one at a time. However when I get to a CREATE TABLE statement that
has a FOREIGN KEY contstraint to a table created 3 sql statments
prior, I get the following error:

This operation is not defined for system tables.
unsuccessful metadata update
object CUSTOMERS is in use

The code does a full attach_db, create_stmt, prep_stmt, execute,
commit, detach_db cycle for each sql statement. I'm lost folks, and
in desperate need of help.

Thanks all.
Ed

--- In firebird-support@yahoogroups.com, "edcurren" <ecurren@a...>
wrote:

> Ah, okay. Thanks Martijn.
>
> --- In firebird-support@yahoogroups.com, "Martijn Tonies"
> <m.tonies@u...> wrote:
> > Ed,
> >
> > You cannot execute multiple statements in one go.
> >
> > With regards,
> >
> > Martijn Tonies
> > Database Workbench - tool for InterBase, Firebird, MySQL, Oracle

& MS

> SQL
> > Server
> > Upscene Productions
> > http://www.upscene.com
> > Database development questions? Check the forum!
> > http://www.databasedevelopmentforum.com