Ok, this is kind of weird, but I am using Firebird 1.5 Release
Candidate 8, and still getting the error for any relation now!

my SQL File:
----------------------
connect 'dbserver/3050:D:\DB\DBDataFile.gdb' user 'sysdba' password
'masterkey';

create table ExampleTable (
code integer not null primary key,
name varchar(100) not null unique,
parent integer);
commit;

alter table ExampleTable
add constraint fk_parent
foreign key (parent) references ExampleTable(code);

commit;
----------------------
I execute this using isql, and still getting the error:

isql -i c:\temp\aa.sql
Use CONNECT or CREATE DATABASE to specify a database
Statement failed, SQLCODE = -607

unsuccessful metadata update
-object EXAMPLETABLE is in use

Any idea what is going on? Is this a DB config param? Or is my db
instance messed up?

Thanks...

--- In firebird-support@yahoogroups.com, Uwe Oeder <uweo@c...> wrote:
> Funny works fine in my system. FireBird 1.5 Release 8.
>
> At 09:27 AM 1/20/2004, you wrote:
> >Hi,
> >
> >I am trying to execute the following SQL which has self-reference:
> >
> > create table ExampleTable (
> > code integer not null primary key,
> > name varchar(100) not null unique,
> > parent integer,
> >
> > foreign key (parent) references ExampleTable(code)
> > );
> >
> >And, this throws an error like:
> >
> >fmSQLEditor.Query:
> >This operation is not defined for system tables.
> >unsuccessful metadata update.
> >object EXAMPLETABLE is in use .
> >
> >Is this a bug?
> >THANKS!..
> >
> >
> >
> >
> >
> >Yahoo! Groups Links
> >
> >To visit your group on the web, go to:
> > http://groups.yahoo.com/group/firebird-support/
> >
> >To unsubscribe from this group, send an email to:
> > firebird-support-unsubscribe@yahoogroups.com
> >
> >Your use of Yahoo! Groups is subject to:
> > http://docs.yahoo.com/info/terms/