Well I have auto commit on, and it doesn't work. I also tried it in
isql by executing the commit command explicitly while some other
connections are going on. No luck.
Any other ideas?

On 17 Jul 2004, at 00:54, Milan Babuskov wrote:

> 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
>
>
>
>
>
>
> Yahoo! Groups Links
>
>
>
>
>
>
--
Geert Bevin Uwyn bvba
"Use what you need" Avenue de Scailmont 34
http://www.uwyn.com 7170 Manage
gbevin[remove] at uwyn dot com Tel +32 64 84 80 03

PGP Fingerprint : 4E21 6399 CD9E A384 6619 719A C8F4 D40D 309F D6A9
Public PGP key : available at servers pgp.mit.edu, wwwkeys.pgp.net