DBF 7 Referential integrity

[ziclope]

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

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
);

Regards

[azyk]

Currently, TDBFUniProvider does not support the specified functionality. We added implementation of referential integrity for TDBFUniProvider to our roadmap.