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