🚀 go-pugleaf

hi brian,

try this first :-

SELECT CUSTOMER
FROM TABLE_1
WHERE SUBMITTED > '01-Dec-2003'

if return 0, confirm there is no record in your database.


"Brian Plotkin" <brian.plotkin@fnc.fujitsu.com> wrote in message
news:406214a4$1@newsgroups.borland.com...
>
> I've tried it in that format and still got 0 records in my
> result set. Any other ideas?
>
> "mymn" <yusairi@yahoo.com> wrote:
> >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??
> >>
> >
> >
>