Re: Oracle + ADOQuery not returning any data

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

Article #1651

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

#1651

From: mymn
Date: Mon, 08 Mar 2004 02:37

40 lines
2211 bytes

for your information,
if you're using Oracle8i, it's not same as SQL Server format in ADO.
please check your date format for SQL Select statement.
try this :-

SELECT CUSTOMER
FROM TABLE_1
WHERE SUBMITTED >= '01-Dec-2003' and SUBMITTED <=  '01-Jan-2004'

or

SELECT CUSTOMER
FROM TABLE_1
WHERE SUBMITTED >= '2003-12-01' and SUBMITTED <=  '2004-01-01'



"Brian Plotkin" <brian.plotkin@fnc.fujitsu.com> wrote in message
news:40327cfc$1@newsgroups.borland.com...
>
> 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: <404bdc47@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!newsfeed2.dallas1.level3.net!news.level3.com!priapus.visi.com!orange.octanews.net!news-out.visi.com!petbe.visi.com!news.octanews.net!newshosting.com!nx02.iad01.newshosting.com!207.69.154.101.MISMATCH!elnk-atl-nf1!newsfeed.earthlink.net!bigfeed2.bellsouth.net!bigfeed.bellsouth.net!news.bellsouth.net!peer01.cox.net!cox.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

References: <40327cfc$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,f885f4d71cea6b34
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2004-03-07 18:38:57 PST
From: "mymn" <yusairi@yahoo.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <40327cfc$1@newsgroups.borland.com>
Subject: Re: Oracle + ADOQuery not returning any data
Date: Mon, 8 Mar 2004 10:37:09 +0800
Lines: 42
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2720.3000
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2727.1300
NNTP-Posting-Host: 219.93.61.50
Message-ID: <404bdc47@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1078713415 219.93.61.50 (7 Mar 2004 18:36:55 -0800)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news2.google.com!newsfeed2.dallas1.level3.net!news.level3.com!priapus.visi.com!orange.octanews.net!news-out.visi.com!petbe.visi.com!news.octanews.net!newshosting.com!nx02.iad01.newshosting.com!207.69.154.101.MISMATCH!elnk-atl-nf1!newsfeed.earthlink.net!bigfeed2.bellsouth.net!bigfeed.bellsouth.net!news.bellsouth.net!peer01.cox.net!cox.net!newsfeeds.ihug.co.nz!ihug.co.nz!newsgroups.borland.com!not-for-mail

Reply to Parent Message