Outer join

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

Article #4121

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

#4121

From: MP
Date: Thu, 21 Mar 2002 08:10

29 lines
1743 bytes

Hi all,
I'm using  C++Builder 5 and ADO. I'm joining two tables with LEFT OUTER
JOIN, for example:

SELECT a.Name, b.Type FROM TableA a LEFT OUTER JOIN TableB b ON b.RecordID =
a.ID.

The result is shown in a data-aware grid and I need to edit the data. But
there are some rows from TableA which don't have corresponding row in
TableB. In this case I need to disable editing the field from TableB (the
value in grid is NULL and I cannot recognize, if there is row in the
underlying TableB with NULL value in this field or the row in TableB doesn't
exist).

How can I solve it?
Thanks.

Sorry for my poor English.
--
Ing. Miloslav Peterka
programmer
ELSYST Engineering
http://www.el-soft.cz


---
Odchoz� zpr�va neobsahuje viry.
Zkontrolov�no antivirov�m syst�mem AVG (http://www.grisoft.cz).
Verze: 6.0.313 / Virov� b�ze: 174 - datum vyd�n�: 2.1.2002

Technical Details

Message-ID: <3c999534_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!peer1-sjc1.usenetserver.com!cyclone2.usenetserver.com!usenetserver.com!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII
X-Google-Thread: 10698b,a9c5c5a97f694c1f,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-03-21 00:19:35 PST
From: "MP" <mpeterka@quick.cz>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Outer join
Date: Thu, 21 Mar 2002 09:10:01 +0100
Lines: 31
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4522.1200
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4522.1200
NNTP-Posting-Host: 193.179.149.101
Message-ID: <3c999534_2@dnews>
X-Trace: dnews 1016698164 193.179.149.101 (21 Mar 2002 00:09:24 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!peer1-sjc1.usenetserver.com!cyclone2.usenetserver.com!usenetserver.com!news02.tsnz.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews