🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

TADOQuery and Oracle keyword MINUS problem

#2314
From: Dino Merentitis
Date: Thu, 14 Aug 2003 14:55
35 lines
1771 bytes
I have a TADOQuery with the below sql

(SELECT DISTINCT(A.ATTPKEY), P.PATPKEY, E.SORTDATE, E.EXAMPKEY, E.LETTERPRINTED FROM
DATAATTEND A, DATAEXAM E, DATAPATIENT P, DATAPATSTATUS S WHERE
A.ATTPKEY = E.ATTKEY AND
P.PATPKEY = A.PATKEY AND
S.PATKEY(+) = P.PATPKEY AND
E.SORTDATE >= '16-09-2003 00:00:00' AND
E.SORTDATE <= '16-09-2004 00:00:00' AND
(S.VALUE1 = '2') AND
(E.STATUS = 10) AND
(1=1) AND
(A.SITEKEY = 1) AND
(1=1) AND
1=1
)
MINUS
(SELECT DISTINCT(A.ATTPKEY), P.PATPKEY, E.SORTDATE, E.EXAMPKEY, E.LETTERPRINTED FROM
DATAATTEND A, DATAEXAM E, DATAPATIENT P, DATAPATSTATUS S WHERE
A.ATTPKEY = E.ATTKEY AND
P.PATPKEY = A.PATKEY AND
S.PATKEY(+) = P.PATPKEY AND
E.SORTDATE >= '16-09-2003 00:00:00' AND
E.SORTDATE <= '16-09-2004 00:00:00' AND
(E.STATUS = 10) AND
(1=1) AND
(A.SITEKEY = 1) AND
(1=1) AND
1=1
)
ORDER BY ATTPKEY, SORTDATE

Any idea what it access violated when I try to open it?

HELP!!!!
Technical Details
Message-ID: <e0e9cde4.0308140655.7de46515@posting.google.com>
Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail

Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,6fe9d4b640b9658f,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-08-14 07:55:48 PST
Path: arc1-ca.pugleaf.net!archiver1.google.com!postnews1.google.com!not-for-mail
From: constantinos.merentitis@torex.com (Dino Merentitis)
Newsgroups: borland.public.cppbuilder.database.ado
Subject: TADOQuery and Oracle keyword MINUS problem
Date: 14 Aug 2003 07:55:47 -0700
Organization: http://groups.google.com/
Lines: 35
Message-ID: <e0e9cde4.0308140655.7de46515@posting.google.com>
NNTP-Posting-Host: 159.170.8.4
Content-Type: text/plain; charset=ISO-8859-1
Content-Transfer-Encoding: 8bit
X-Trace: posting.google.com 1060872948 22159 127.0.0.1 (14 Aug 2003 14:55:48 GMT)
X-Complaints-To: groups-abuse@google.com
NNTP-Posting-Date: 14 Aug 2003 14:55:48 GMT