Article View: borland.public.cppbuilder.database.multi-tier
Article #1448Re: c++ master/detail tables
From: Jean Ferreira
Date: Fri, 10 Sep 1999 00:00
Date: Fri, 10 Sep 1999 00:00
42 lines
2085 bytes
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 > > > >
Technical Details
Message-ID:
<7ravpt$rbn6@forums.borland.com>Path:
arc1-ca.pugleaf.net!unknown!not-for-mailReferences:
<7rag46$nc05@forums.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: fcd2b,170e4f6ca6bc82e7 X-Google-Attributes: gidfcd2b,public From: "Jean Ferreira" <jean@squadra.com.br> Subject: Re: c++ master/detail tables Date: 1999/09/10 Message-ID: <7ravpt$rbn6@forums.borland.com> X-Deja-AN: 523370930 References: <7rag46$nc05@forums.borland.com> X-Priority: 3 X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2014.211 Organization: Another Netscape Collabra Server User X-MSMail-Priority: Normal Newsgroups: borland.public.cppbuilder.database.multi-tier