TADOQuery with MSAcess 2000

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

Article #5466

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

#5466

From: Juan Carlos
Date: Fri, 11 May 2001 17:17

18 lines
1456 bytes

Hi, All

I try to run a query command like this:

SELECT HE.CALLDATE,HE.DURATION,GR.BOXNAME,GR.TRANSACTION FROM IVRCHANNELHEADER AS HE, IVRCHANNELDETAIL AS GR WHERE HE.TRANSACTION=GR.TRANSACTION AND HE.CALLDATE <= #%s# ORDER BY HE.TRANSACTION,Aux_Data)

where Aux_Data is an AnsiString
Aux_Data = FormatDateTime("dd/mm/yyyy hh:nn:ss", Now());
and the fields HE.CALLDATE is MSAcess DateTime field
How I compare this two values? When I run the application I get
an error:"Parameter object is improperly defined. Inconsistent
or incomplete information was provided".
Any Idea?

Thank in advanced

Juan

Technical Details

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

Path:

arc1-ca.pugleaf.net!archiver1.sj.google.com!newsfeed.google.com!sn-xit-03!supernews.com!logbridge.uoregon.edu!newsfeed.skycache.com!Cidera!newsfeed.gamma.ru!Gamma.RU!news.algonet.se!algonet!newsfeed1.uni2.dk!newssuck.uni2.dk!dnews

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,751fcabbfb64a762,start
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-05-11 10:38:30 PST
From: "Juan Carlos" <juan@lm.com.br>
Sender: "Juan Carlos" <juan@lm.com.br>
Reply-To: "Juan Carlos" <juan@lm.com.br>
Subject: TADOQuery with MSAcess   2000
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 200.182.209.214 200.182.209.214    
NNTP-Posting-Host: 207.105.83.65
Message-ID: <3afc1ebb$1_1@dnews>
Date: 11 May 2001 10:17:47 -0700
X-Trace: dnews 989601467 207.105.83.65 (11 May 2001 10:17:47 -0700)
Lines: 18
Path: arc1-ca.pugleaf.net!archiver1.sj.google.com!newsfeed.google.com!sn-xit-03!supernews.com!logbridge.uoregon.edu!newsfeed.skycache.com!Cidera!newsfeed.gamma.ru!Gamma.RU!news.algonet.se!algonet!newsfeed1.uni2.dk!newssuck.uni2.dk!dnews