Oracle + ADOQuery not returning any data

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

Article #1747

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

#1747

From: Brian Plotkin
Date: Tue, 17 Feb 2004 20:43

20 lines
1506 bytes

Hello all,

--> Sorry for the cross post, I meant to post this message 
here, not in the sqlservers group. <--

I have a simple query :
SELECT CUSTOMER, SUBMITTED FROM TABLE_1 
WHERE SUBMITTED BETWEEN '01-Dec-2003' AND '01-Jan-2004'

If I submit this query through SQL Explorer, I get what I
expect. 

If I submit this query through an ADOQuery in my application,
I get a result set of 0 (zero) records.

The database is Oracle 8i and my compiler is BCB 6 (Enterprise),
in case you wanted to know.

Any ideas??

Technical Details

Message-ID: <40327cfc$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!nx02.iad01.newshosting.com!newshosting.com!newshosting.com!nx01.iad01.newshosting.com!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,f885f4d71cea6b34,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2004-02-17 12:47:29 PST
From: "Brian Plotkin" <brian.plotkin@fnc.fujitsu.com>
Sender: "Brian Plotkin" <brian.plotkin@fnc.fujitsu.com>
Reply-To: "Brian Plotkin" <brian.plotkin@fnc.fujitsu.com>
Subject: Oracle + ADOQuery not returning any data
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 168.127.0.52     
X-Forwarded-For: 167.254.147.91
NNTP-Posting-Host: 207.105.83.66
Message-ID: <40327cfc$1@newsgroups.borland.com>
Date: 17 Feb 2004 12:43:40 -0800
X-Trace: newsgroups.borland.com 1077050620 207.105.83.66 (17 Feb 2004 12:43:40 -0800)
Lines: 21
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!news.maxwell.syr.edu!nx02.iad01.newshosting.com!newshosting.com!newshosting.com!nx01.iad01.newshosting.com!203.109.252.33.MISMATCH!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail