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
>
>
>
>
>
>
>
>