Article View: borland.public.cppbuilder.database.ado
Article #3082Re: Query problem with MSSQL using ADO
From: Andre Hayward
Date: Mon, 16 Dec 2002 06:06
Date: Mon, 16 Dec 2002 06:06
16 lines
1463 bytes
1463 bytes
"bmkiss67" <bmkiss67@aaahawk.com> wrote:
>Just upgraded to from BCB5 to BCB6 and changed BDE out for ADO. Now one of
>our queries does not work correctly.
> qRooms->Close();
> qRooms->SQL->Clear();
> qRooms->SQL->Add("Select * from Billeting where (SDATE >=:startdate and");
> qRooms->SQL->Add("SDATE <=:enddate) or (EDATE >=:startdate and");
Don't know if this will help but I found that the data parameters must
be of type char. If the type is an integer the query does not work.
HTH
Andre
Technical Details
Message-ID:
<3dfd550f@newsgroups.borland.com>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mailReferences:
<3def7876@newsgroups.borland.com>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,885632d609f12fd7 X-Google-Attributes: gid10698b,public X-Google-Thread: fc5f9,885632d609f12fd7 X-Google-Attributes: gidfc5f9,public X-Google-ArrivalTime: 2002-12-15 20:30:37 PST From: jorhaypi@mweb.co.za (Andre Hayward) Newsgroups: borland.public.cppbuilder.database.ado,borland.public.cppbuilder.database.sqlservers Subject: Re: Query problem with MSSQL using ADO Date: Mon, 16 Dec 2002 06:06:22 GMT Organization: Jordaan Hayward Inc. References: <3def7876@newsgroups.borland.com> X-Newsreader: Forte Free Agent 1.0.82 NNTP-Posting-Host: 196.31.186.158 Message-ID: <3dfd550f@newsgroups.borland.com> X-Trace: newsgroups.borland.com 1040012559 196.31.186.158 (15 Dec 2002 20:22:39 -0800) Lines: 17 Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!newsgroups.borland.com!not-for-mail