I get the following error:
General error;-7040 POS(1) Referential constraint not allowed. with the
following DML code:
create table TBL_USERS (
NAME varchar(64) key
)
//
create table TBL_FOLDERS (
ID integer key,
NAME varchar(64) not null,
USER_NAME varchar(64) references TBL_USERS on delete cascade
)
//
create table TBL_ACCOUNTS (
ID integer key,
NAME varchar(64) not null,
USER_NAME varchar(64) references TBL_USERS on delete cascade,
FOLDER_ID integer references TBL_FOLDERS on delete set null
)
If I change the last constraint to:
FOLDER_ID integer references TBL_FOLDERS on delete cascade
It works, but this is NOT what I want...
Am I doing something wrong or did I hit a limitation of SapDB referential
integrity implementation...
Thanks for any help on the subject...
Benoit
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
