cascade delete difference

Thread View: borland.public.interbase.ibconsole

6 messages

[T] Back to Threads [V] Tree View [G] Group Articles

6 total messages Started by dan palley Mon, 26 Nov 2007 19:18

#72

Author: 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.

Re: cascade delete difference

#73

Author: 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.

Re: cascade delete difference

#75

Author: Gelein van de Voorde
Date: Tue, 27 Nov 2007 19:56

8 lines
1174 bytes

> Gelein, thanks.  I've determined that the grid on the Table Editor
> screen is wrong.  If you have more than one constraint, the settings
> for the 2nd one appear duplicated on the first one.  I've sent you
> some screen snaps via email.  Let me know if you didn't receive them.

Dan,
I got your mail. It helped me to find the bug, which will be fixed in
the next beta release. Hope you got my reply too.

Re: cascade delete difference

#74

Author: dan palley
Date: Tue, 27 Nov 2007 20:52

32 lines
2106 bytes

"Gelein van de Voorde" <gelein@gvsnet.nl> wrote in message 
news:474b3540$1@newsgroups.borland.com...
> 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.

Gelein, thanks.  I've determined that the grid on the Table Editor screen is 
wrong.  If you have more than one constraint, the settings for the 2nd one 
appear duplicated on the first one.  I've sent you some screen snaps via 
email.  Let me know if you didn't receive them.

Dan

Re: cascade delete difference

#76

Author: dan palley
Date: Wed, 28 Nov 2007 18:13

16 lines
1620 bytes

"Gelein van de Voorde" <gelein@gvsnet.nl> wrote in message 
news:474c8466$1@newsgroups.borland.com...
>> Gelein, thanks.  I've determined that the grid on the Table Editor
>> screen is wrong.  If you have more than one constraint, the settings
>> for the 2nd one appear duplicated on the first one.  I've sent you
>> some screen snaps via email.  Let me know if you didn't receive them.
>
> Dan,
> I got your mail. It helped me to find the bug, which will be fixed in
> the next beta release. Hope you got my reply too.

I didn't see your reply.  Can you resend?

Thanks,

Dan

Re: cascade delete difference

#77

Author: Gelein van de Voorde
Date: Wed, 28 Nov 2007 18:34

1 lines
844 bytes

I just did.

Thread Navigation

This is a paginated view of messages in the thread with full content displayed inline.

Messages are displayed in chronological order, with the original post highlighted in green.

Use pagination controls to navigate through all messages in large threads.

Back to All Threads