Hi Jason,
This application is the only thing running on my PC. Is there a
delay after isc_dsql_detach()? That is the only thing I can think of
that may be at issue here.

Thanks.
Ed

--- In firebird-support@yahoogroups.com, Jason Dodson <jasond@b...>
wrote:

> You must have more then one connection to the database... only one

can

> be attached for you to be able to make such changes.
>
> Jason
>
> edcurren wrote:
> > 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
> >
> >
> >
> >
> >
> > ++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++++
> >
> > Visit http://firebird.sourceforge.net 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
> >
> >
> >
> >
> >
> >
> >
> >