Master Detail relationship with TSQLClientDataSet

Article View: borland.public.cppbuilder.database.dbexpress

Article #148

Back to borland.public.cppbuilder.database.dbexpress Previous Next

#148

From: Vanessa Deagan
Date: Wed, 03 Aug 2005 12:49

28 lines
1944 bytes

Hi,

I'm using BCB6 Ent and MySQL 4.0.23. I'm trying to setup a master/detail 
relationship using:

SQLConnection1
SQLClientDataSet1, DataSource1
SQLClientDataSet2, DataSource2


The master TSQLClientDataSet:
SQLClientDataSet1->CommandText = "select id, parent_id, name from Category 
where parent_id = :parent_id";

The detail TSQLClientDataSet:
SQLClientDataSet2->CommandText = "select cat_id, board_name from 
BoardCateogryMap where cat_id = :id";

I then set SQLClientDataSet2.MasterSource to DataSource1, and I then press 
the eclipse for SQLClientDataSet2's MasterFields property, and this brings 
up the "Field Link Designer". I select the fields used in the relationship 
(Detail Field = cat_id, Master Field = id), but am then greeted with a 
"Field id not found".

Could someone please post simple instructions to setup master/detail 
relationship usnig TSQLClientDataSets.

Many thanks.

Technical Details

Message-ID: <42f0bd64$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!newsfeed.hal-mli.net!feeder1.hal-mli.net!news-out.newsfeeds.com!propagator3-LAX.newsfeeds.com!news-in.spamkiller.net!news-in.superfeed.net!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: fb4e2,e05bc17277e788ff,start
X-Google-Attributes: gidfb4e2,public
X-Google-Language: ENGLISH,ASCII-7-bit
Reply-To: "Vanessa Deagan" <VanessaDeagan@yahoo.co.uk>
From: "Vanessa Deagan" <VanessaDeagan@yahoo.co.uk>
Newsgroups: borland.public.cppbuilder.database.dbexpress
Subject: Master Detail relationship with TSQLClientDataSet
Date: Wed, 3 Aug 2005 13:49:40 +0100
Lines: 30
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2900.2527
X-RFC2646: Format=Flowed; Original
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2900.2527
NNTP-Posting-Host: 217.12.14.240
Message-ID: <42f0bd64$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1123073380 217.12.14.240 (3 Aug 2005 05:49:40 -0700)
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news.glorb.com!newsfeed.hal-mli.net!feeder1.hal-mli.net!news-out.newsfeeds.com!propagator3-LAX.newsfeeds.com!news-in.spamkiller.net!news-in.superfeed.net!caladan.landsraad.net!newsgroups.borland.com!not-for-mail