Hello All,
Is the following SQL statement(especially the key section) possible in 
Delphi? Is it possible in Delphi 3? I'm now using Delphi 2.0. It's to be used 
in a stand-alone application.
CREATE TABLE PERSON (
NAME      VARCHAR(25) NOT NULL,
NR        INT         NOT NULL,
RELATEDTO INT         NOT NULL   DEFAULT 0,
PRIMARY KEY (NR),
FOREIGN KEY (RELATEDTO) REFERENCES PERSON(NR)
  ON DELETE SET DEFAULT ON UPDATE CASCADE );
CYa,
Matheas (M.S.L.F.Manssen@wing.rug.nl)
--- FMail/386 1.02
---------------