Article View: borland.public.cppbuilder.database.ado
Article #2107Wrong RowCount when select distinct
From: xiao zhen
Date: Thu, 06 Nov 2003 09:21
Date: Thu, 06 Nov 2003 09:21
18 lines
1510 bytes
1510 bytes
I am using BCB6 Enterprise + Update4, connect to oracle 8i by ADO. I have 2 tables depts( deptid Number(10) NOT NULL, deptName varchar2(100) ) has values ( 1, 'aaa' ), (2, 'bbb') modality( modalityid Number(4) NOT NULL, deptid Number(10) ) has values ( 1, 1 ), (2, 1), (3, 2), (4,2) when I use open a TADOQuery object with SQL as "select distinct d.deptid, d.deptname from depts d, modality m where d.deptid = m.deptid" the Query->RowCount is 4, not 2! when I execute the same command by Oracle SQLPlus, result is 2. who can help me?
Technical Details
Message-ID:
<3faa11a9$1@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newshosting.com!news-xfer2.atl.newshosting.com!news-out.superfeed.net!propagator2-maxim!news-in.superfeed.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mailShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,a1e498625b8e8d37,start X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2003-11-06 01:25:43 PST From: "xiao zhen" <zhenx@vip.sina.com> Newsgroups: borland.public.cppbuilder.database.ado Subject: Wrong RowCount when select distinct Date: Thu, 6 Nov 2003 17:21:42 +0800 Lines: 22 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 218.19.218.11 Message-ID: <3faa11a9$1@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1068110249 218.19.218.11 (6 Nov 2003 01:17:29 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!newshosting.com!news-xfer2.atl.newshosting.com!news-out.superfeed.net!propagator2-maxim!news-in.superfeed.net!newsfeed01.tsnz.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail