c++ master/detail tables

Thread View: borland.public.cppbuilder.database.multi-tier

3 messages

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

3 total messages Started by Kjanisz Fri, 10 Sep 1999 00:00

#1452

Author: Kjanisz
Date: Fri, 10 Sep 1999 00:00

15 lines
1214 bytes

Hello, I have a little problem.
I'm writing mulit-tiered application and I have :
on server-side data module
    - two table joined with master source/detail
    - TProvider component connected with these table.
on client-side I have all needed components (Tables, DataSources)

I want to use cascading deletes. I have set the refferential integrity in
Database desktop, options in Provider ( poCascadeDeletes ) and when I try to
delete record in master table I get an event with message "Master has detail
records. Cannot delete or modify". What I did wrong, what is the problem.
Plese send replys with copy to my e-mail addres: kjanisz@poczta.onet.pl

Thanks you in advance
Krzysztof Janiszewski

Re: c++ master/detail tables

#1448

Author: Jean Ferreira
Date: Fri, 10 Sep 1999 00:00

42 lines
2085 bytes

Kjanisz,

Text from help of Delphi:

poCascadeDeletes Tells the server to delete detail records automatically
when master table records are deleted. To use this option, the provider must
represent the master of a master/detail relationship and the database must
support cascaded deletes as part of its referential integrity settings.

poCascadeUpdates Tells the server to update detail records automatically
when master table key values are changed. To use this option, the provider
must represent the master of a master/detail relationship and the database
must support cascaded updates as part of its referential integrity settings.


Whish DBMS are you using ??

Jean

Kjanisz <kjanisz@poczta.onet.pl> wrote in message
news:7rag46$nc05@forums.borland.com...
> Hello, I have a little problem.
> I'm writing mulit-tiered application and I have :
> on server-side data module
>     - two table joined with master source/detail
>     - TProvider component connected with these table.
> on client-side I have all needed components (Tables, DataSources)
>
> I want to use cascading deletes. I have set the refferential integrity in
> Database desktop, options in Provider ( poCascadeDeletes ) and when I try
to
> delete record in master table I get an event with message "Master has
detail
> records. Cannot delete or modify". What I did wrong, what is the problem.
> Plese send replys with copy to my e-mail addres: kjanisz@poczta.onet.pl
>
> Thanks you in advance
> Krzysztof Janiszewski
>
>
>
>

Re: c++ master/detail tables

#1460

Author: Kjanisz
Date: Sun, 12 Sep 1999 00:00

8 lines
679 bytes

> Whish DBMS are you using ??
>
> Jean

I'm using BDE 5.01.

Kjanisz
kjanisz@friko7.onet.pl

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