🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.multi-tier
Article #811

ClientDataSet MasterDetail relations

#811
From: Keuning
Date: Mon, 23 Oct 2000 00:00
23 lines
1618 bytes
Hi there and thanks for reading,

I'm trying to create a Master-Detail relation between two ClientDataSets.
When I call 'ApplyUpdates' for the Master-ClientDataSet after inserting a
record in both, the Detail-ClientDataSet also gets posted, but not applied
to the database. So I call 'ApplyUpdates' for the Detail-ClientDataSet too.
All goes well, except for the Detail-ClientDataSet. It's data does appear in
the database, but all data-aware components linked to the
Detail-ClientDataSet appear empty. When I call Refresh(), the link between
the master and the Detail-ClientDataSet is "Lost" and all detail information
isn't displayed anymore (for no Master-record). We're using SQL Server 6 and
C++ Builder 4.0.

What could be the problem? I do use the Detail-ClientDataSet for certain
Lookup Fields in the Master-ClientDataSet. The ClientDataSets are linked to
TDataSetProviders which are linked to TQuery's, all on the same form...

Help would be greatly appreciated, 'cause I've been working on it for two
days...

Thanks in advance,

Erwin.
Technical Details
Message-ID: <8t1g78$meu20@bornews.borland.com>
Path: arc1-ca.pugleaf.net!unknown!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,99fad490044ee72f,start
X-Google-Attributes: gidfcd2b,public
From: "Keuning" <ekeuning@snakeware.nl>
Subject: ClientDataSet MasterDetail relations
Date: 2000/10/23
Message-ID: <8t1g78$meu20@bornews.borland.com>
X-Deja-AN: 684815589
X-Priority: 3
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2314.1300
Organization: Snakeware IT Solutions BV
X-MSMail-Priority: Normal
Reply-To: "Keuning" <ekeuning@snakeware.nl>
Newsgroups: borland.public.cppbuilder.database.multi-tier