cascade delete difference

Article View: borland.public.interbase.ibconsole

Article #72

Back to borland.public.interbase.ibconsole Previous Next

#72

From: dan palley
Date: Mon, 26 Nov 2007 19:18

17 lines
1586 bytes

Gelein:

I have a database that has had some metadata changes made.  Prior to making 
the changes, a particular FK constraint shows cascade delete and works 
correctly.  After making the changes, the metadata for the FK still shows as 
cascade delete, but looking at the FK via the table editor shows RESTRICT. 
I assume that the table editor is looking for the DELETE condition in some 
other system table.  Can you let me know what query the Table Editor is 
using to display FK information?

We're still trying to track down what's causing the problem.  The FK works 
fine in IB 7.1 but not in IB 2007.

Thanks,

Dan Palley
TRAMS, Inc.

Technical Details

Message-ID: <474b1c03$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!club-internet.fr!feedme-small.clubint.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: f4565,e22a5923e772a343,start
X-Google-Attributes: gidf4565,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "dan palley" <dan@trams.com>
Newsgroups: borland.public.interbase.ibconsole
Subject: cascade delete difference
Date: Mon, 26 Nov 2007 11:18:43 -0800
Lines: 19
Organization: TRAMS
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.3790.3959
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.3790.4133
X-RFC2646: Format=Flowed; Original
NNTP-Posting-Host: 66.102.131.254
Message-ID: <474b1c03$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1196104707 66.102.131.254 (26 Nov 2007 11:18:27 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!feeder1-2.proxad.net!proxad.net!feeder1-1.proxad.net!club-internet.fr!feedme-small.clubint.net!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail