ON DELETE CASCADE ADO

Article View: borland.public.cppbuilder.database.ado

Article #4182

Back to borland.public.cppbuilder.database.ado Previous Next

#4182

From: David Barnes
Date: Wed, 13 Mar 2002 17:18

22 lines
1629 bytes

I either have a syntax problem or ADO doesn't do this.

Basicaly I have a statement similiar to this:

Create Table XYZ
(
   ID INT NOT NULL UNIQUE PRIMARY KEY,
   FNAME VARCHAR(20),

   CONSTRAINT ID_fk FOREIGN KEY ( ID ) REFERENCES ABC ON DELETE CASCADE
)


When I use the Database Explorer to do this everything will work except 
for when I add the ON DELETE CASCADE. If I remove that, it will work. If 
I try it with it, I get a Contraint error.

Please note that I do drop the table before hand and I do have rights to 
do this as I am the one that created the database to begin with.

Any ideas would be great.
Thanks

Technical Details

Message-ID: <3C8F89F0.5020500@kalos-inc.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!attbtf!ip.att.net!wn3feed!wn1feed!worldnet.att.net!64.154.60.72!cyclone2.usenetserver.com!usenetserver.com!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,cd129d8a53dbf37d,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-03-13 09:20:20 PST
Message-ID: <3C8F89F0.5020500@kalos-inc.com>
Date: Wed, 13 Mar 2002 11:18:40 -0600
From: David Barnes <david@kalos-inc.com>
User-Agent: Mozilla/5.0 (Windows; U; WinNT4.0; en-US; rv:0.9.4) Gecko/20011019 Netscape6/6.2
X-Accept-Language: en-us
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: ON DELETE CASCADE ADO
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 65.69.231.139
X-Trace: dnews 1016039859 65.69.231.139 (13 Mar 2002 09:17:39 -0800)
Lines: 23
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!attbtf!ip.att.net!wn3feed!wn1feed!worldnet.att.net!64.154.60.72!cyclone2.usenetserver.com!usenetserver.com!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews