I've made an application that create tables, indices and foreign key over an
interbase server (Both Win and Solaris platform).

All is Ok except the phase in which i create the foreign key.

The database answer me this message:

unsuccesful metadata update; table <TableName> is in use

I already try to commit every operation (create table, create index, ...)
but the result is always the same.

Does anyone have a solution ?
--
Marco Battisti

"Marco Battisti" <m.batti...@zucchettittools.com> ha scritto nel messaggio
news:3af95358_1@dnews...>

I found the same problem when trying to update a database structure in
manual mode.

My solution (quite rude, indeed) was:
  shutdown the database
  drop every connection to db (except the one used for updating the
structure)

I guess you can create foreign key with only one connection open

HTH
Marco Dugoni

        Correct.

        -Craig

--
Craig Stuntz (TeamB)       Senior Developer, Vertex Systems Corp.
Delphi/InterBase weblog:   http://delphi.weblogs.com
Use Borland servers; posts via others are not seen by TeamB.
For more info, see http://www.borland.com/newsgroups/genl_faqs.html