Hi,
I posted this problem some days ago, but didn't get any
informative reply.
So I am posting it again.
My sap db server is running on windows 2000 machine.
I installed sap db server using:
sapdb-server-win-32bit-i386-7_3_0_24.tgz
and the sql studio: sqlstudio74-setup.exe
I am not sure if this is a known issue or not. I have 3 tables,
and two tables have foreign key references to the first table.
If I insert a row in the first table, I can't delete it anymore
even if there is no foreign key constraint on that row.
This sql script works fine on my ms sql server (ofcourse, with
appropriate syntax change).
Please let me know I am doing wrong!
Thanks and regards,
~dil
CREATE TABLE TABLE_A
(
COL1 INTEGER
CONSTRAINT TABLE_A_PK PRIMARY KEY,
COL2 VARCHAR(32) NOT NULL
CONSTRAINT TABLE_A_UQ UNIQUE
)
//
CREATE TABLE TABLE_B
(
COL2 VARCHAR(32)
CONSTRAINT TABLE_B_FK REFERENCES TABLE_A(COL2)
)
//
CREATE TABLE TABLE_C
(
COL1 INTEGER NOT NULL
CONSTRAINT TABLE_C_FK REFERENCES TABLE_A(COL1)
)
//
INSERT INTO TABLE_A VALUES (1, 'Default')
//
-- this statement doesnt work
DELETE FROM TABLE_A
//
-- these statements work
CREATE TABLE TABLE_D
(
COL1 INTEGER
CONSTRAINT TABLE_A_PK PRIMARY KEY,
COL2 VARCHAR(32) NOT NULL
CONSTRAINT TABLE_A_UQ UNIQUE
)
//
INSERT INTO TABLE_D VALUES (1, 'Default')
//
DELETE FROM TABLE_D
//
________________________________________________
Get your own "800" number
Voicemail, fax, email, and a lot more
http://www.ureach.com/reg/tag
_______________________________________________
sapdb.general mailing list
[EMAIL PROTECTED]
http://listserv.sap.com/mailman/listinfo/sapdb.general
