Geert Bevin wrote:

> I'm trying to create foreign keys during the definition of a table, for
> instance like this:
> create table car (id INT NOT NULL PRIMARY KEY, name varchar(10));

commit;

> create table person (id INT NOT NULL PRIMARY KEY, carid INTEGER,
> FOREIGN KEY (carid) REFERENCES car (id));
>
> I get the following error message if I'm not the only one connected to
> the database:
> Statement failed, SQLCODE = -607
> unsuccessful metadata update
> -object CAR is in use

HTH

--
Milan Babuskov
http://fbexport.sourceforge.net