ado Query DateTime Problem

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

Article #3533

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

#3533

From: Thomas Wasner
Date: Tue, 30 Jul 2002 07:24

18 lines
1414 bytes

Hi all,

when i try to get part of the dataset's out aof a access db with an ADO
Query and the following SQL Statement i always get error message and no
result:

select * from events where datetime > #2002/07/30 08:00:00#;

this stement works fine in Access but with the ADO Querry i get 'th is
objekt is nor perely assigned or there are missing Information' when i
do the statement without the Time it's working, so this statement works:

select * from events where datetime > #2002/07/30#;

who has an Idea, every Hint's is appreciated,

thank's in advance
Thomas

Technical Details

Message-ID: <3D463F31.674E9603@wasner.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,19dca84e03158e72,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-07-30 00:36:03 PST
Message-ID: <3D463F31.674E9603@wasner.com>
Date: Tue, 30 Jul 2002 09:24:33 +0200
From: Thomas Wasner <wasner@wasner.com>
X-Mailer: Mozilla 4.76 [en] (Windows NT 5.0; U)
X-Accept-Language: en
MIME-Version: 1.0
Newsgroups: borland.public.cppbuilder.database.ado
Subject: ado Query DateTime Problem
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 62.153.165.123
X-Trace: dnews 1028013855 62.153.165.123 (30 Jul 2002 00:24:15 -0700)
Lines: 20
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-01!sn-xit-04!supernews.com!news.maxwell.syr.edu!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews