Article View: borland.public.cppbuilder.database.ado
Article #2314TADOQuery and Oracle keyword MINUS problem
From: Dino Merentitis
Date: Thu, 14 Aug 2003 14:55
Date: Thu, 14 Aug 2003 14:55
35 lines
1771 bytes
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-mailShow 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