SQL Query On an Access Database ?

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

Article #3772

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

#3772

From: Peter Moscatt
Date: Fri, 21 Jun 2002 04:27

13 lines
1364 bytes

I am trying to use the following code in an sql query to bring data into a MS Access database.  Using C++ Builder 6.

QueryStr = "SELECT * FROM EventList WHERE EventTime = 11/10/2000 7:35:15 AM";

When I make this actice, I get the following error message:
'Parameter object is improperly defined. Inconsistant or incomplete information was provided'

When I use the query without the time, all is well but as soon as I put the time in, it fails.
The Access field type is Date/Time.

Regards
Pete

Technical Details

Message-ID: <3d12ab37$1_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!yellow.newsread.com!bad-news.newsread.com!netaxs.com!newsread.com!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,689888911672d1a5,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-06-20 21:30:27 PST
From: "Peter Moscatt" <pgmoscatt@optushome.com.au>
Sender: "Peter Moscatt" <pgmoscatt@optushome.com.au>
Reply-To: "Peter Moscatt" <pgmoscatt@optushome.com.au>
Subject: SQL Query On an Access Database  ?
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 203.2.231.20 203.2.231.20    
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3d12ab37$1_1@dnews>
Date: 20 Jun 2002 21:27:35 -0700
X-Trace: dnews 1024633655 207.105.83.65 (20 Jun 2002 21:27:35 -0700)
Lines: 14
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-03!supernews.com!yellow.newsread.com!bad-news.newsread.com!netaxs.com!newsread.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!dnews