DBF 7 Referential integrity
Posted: Fri 20 Oct 2017 11:20
Hello,
I am trying new driver for DBF but I have an issue
When I delete master record, it does not delete details see tables below
Regards
I am trying new driver for DBF but I have an issue
When I delete master record, it does not delete details see tables below
Code: Select all
CREATE TABLE CUSTOMER
(
CUSTNO INTEGER NOT NULL,
COMPANY CHAR(30),
PRIMARY KEY CUSTNO
);
CREATE TABLE CUSTOMER_ADDRESS
(
ID_ADDRESS INTEGER NOT NULL,
CUSTNO INTEGER FOREIGN KEY REFERENCES CUSTOMER (CUSTNO) ON DELETE CASCADE ON UPDATE CASCADE,
ADDRESS CHAR(30),
PRIMARY KEY ID_ADDRESS
);