Question about ADO and Access

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

Article #2400

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

#2400

From: afatdog
Date: Tue, 15 Jul 2003 14:31

16 lines
1464 bytes

I use TADOConnection to connect a database, Access 2000.

ADOQuery->SQL->Add("select");
ADOQuery->SQL->Add("    *");
ADOQuery->SQL->Add("from");
ADOQuery->SQL->Add("    T_XXXX");
ADOQuery->SQL->Add("where");
ADOQuery->SQL->Add("        (.....)");
ADOQuery->SQL->Add(" AND (DateTime >= #2002-07-15 00:00:00#)"); // here
ADOQuery->SQL->Add(" AND (DateTime <= #2003-07-15 23:59:59#)"); // here
ADOQuery->Open();

There is some exception was throw : "Parameter object is improperly defined.
Inconsistent or incomplete information was provided".
But this SQL can be correct execute in Access.
Where is wrong?

Technical Details

Message-ID: <3f14100d@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!newsfeed.wirehub.nl!news.kweb.on.ca!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,f6df55237653b6e2,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-07-15 07:36:03 PST
From: "afatdog" <afatdog.hn@yeah.net>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Question about ADO and Access
Date: Tue, 15 Jul 2003 22:31:01 +0800
Lines: 19
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1106
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1106
NNTP-Posting-Host: 211.157.248.35
Message-ID: <3f14100d@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1058279437 211.157.248.35 (15 Jul 2003 07:30:37 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-03!sn-xit-01!sn-xit-09!supernews.com!newsfeed.wirehub.nl!news.kweb.on.ca!newsgroups.borland.com!not-for-mail