Re: cascade delete difference

Article View: borland.public.interbase.ibconsole

Article #73

Back to borland.public.interbase.ibconsole Previous Next

#73

From: Gelein van de Voorde
Date: Mon, 26 Nov 2007 20:06

22 lines
1611 bytes

dan palley wrote:

> 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.
Dan,
The table editor displays the RDB$DELETE_RULE field of
RDB$REF_CONSTRAINTS.

Technical Details

Message-ID: <474b3540$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!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <474b1c03$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Thread: f4565,e22a5923e772a343
X-Google-Attributes: gidf4565,public,usenet
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Gelein van de Voorde" <gelein@gvsnet.nl>
Subject: Re: cascade delete difference
Newsgroups: borland.public.interbase.ibconsole
References:  <474b1c03$1@newsgroups.borland.com>
User-Agent: XanaNews/1.18.1.6
NNTP-Posting-Host: 82.173.185.201
Message-ID: <474b3540$1@newsgroups.borland.com>
Date: 26 Nov 2007 13:06:08 -0700
X-Trace: newsgroups.borland.com 1196111168 82.173.185.201 (26 Nov 2007 13:06:08 -0700)
Lines: 22
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!newsfeed.freenet.de!newsfeed00.sul.t-online.de!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message