Can't access database with the date data type field

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

Article #3491

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

#3491

From: Jackie
Date: Sat, 10 Aug 2002 23:25

16 lines
1285 bytes

Hi All
I have a Access database with several table which all have a (short date
format) data type field , where i try to query it by execute the following
SQL statement .

Select * from table1 where dater =  31/7/2002
or
Select * from table1 where dater =  '31/7/2002'
or
Select * from table1 where dater =  #31/7/2002#

I got nothing , I'm sure that at least one record have the date "31/7/2002".
did i do something wrong.

Please help
Thanks a lot

Technical Details

Message-ID: <3d55a14f$1_2@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-08!supernews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,47a4773167bac670,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-08-10 16:34:30 PST
From: "Jackie" <tkfi@hotmail.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Can't access database with the date data type field
Date: Sun, 11 Aug 2002 07:25:26 +0800
Lines: 22
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4807.1700
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4910.0300
NNTP-Posting-Host: 202.175.76.166
Message-ID: <3d55a14f$1_2@dnews>
X-Trace: dnews 1029022031 202.175.76.166 (10 Aug 2002 16:27:11 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-08!supernews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews!not-for-mail