Incorrect SQL behavior

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

Article #4857

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

#4857

From: Hardee Mahoney
Date: Wed, 19 Sep 2001 13:10

22 lines
1520 bytes

Hello,

BCB5 SP1 on NT

I have an ADOConnection to a SQL Server 6.5 database using a Data Link
File.  I have an ADOQuery associated with that connection with the
following SQL:

SELECT DISTINCT simple_plantype
FROM medigap_plantype_xwalk
ORDER BY simple_plantype

I have a DataSource object and a DBGrid.

The SQL statement returns all rows in the table, completely disregarding
the DISTINCT keyword.  Has anyone seen this?  Is there anything to fix
it short of reading all the rows and deduping them in code?

Thanks in advance

Hardee Mahoney
Washington, DC

Technical Details

Message-ID: <3BA89961.92374FCA@nerdvana.fu.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!newsfeed.google.com!sn-xit-02!supernews.com!62.53.226.180.MISMATCH!feedme.news.mediaways.net!newsfeed00.sul.t-online.de!t-online.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,79563bdbb3a120de,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-09-19 06:22:27 PST
Message-ID: <3BA89961.92374FCA@nerdvana.fu.com>
Date: Wed, 19 Sep 2001 09:10:57 -0400
From: Hardee Mahoney <mahoney@nerdvana.fu.com>
X-Mailer: Mozilla 4.77 [en] (WinNT; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Incorrect SQL behavior
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 63.83.108.2
X-Trace: dnews 1000905269 63.83.108.2 (19 Sep 2001 06:14:29 -0700)
Lines: 24
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!newsfeed.google.com!sn-xit-02!supernews.com!62.53.226.180.MISMATCH!feedme.news.mediaways.net!newsfeed00.sul.t-online.de!t-online.de!news-spur1.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews