Re: ado Query DateTime Problem

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

Article #3471

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

#3471

From: Jerry Irons
Date: Fri, 02 Aug 2002 23:46

12 lines
1123 bytes

Hello,

Try this:

QueryName->Parameters->ParamByName("dateparameter")->Value = Now();
//where dateparameter is datetime 

select * from tablename where orderdate > :dateparameter

Just a thought, didn't test it myself.

-Jerry

Technical Details

Message-ID: <r36mku86r9am428miqkmod4v68uflosg7l@4ax.com>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-06!sn-xit-04!supernews.com!news.maxwell.syr.edu!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews!not-for-mail

References: <3D463F31.674E9603@wasner.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,19dca84e03158e72
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2002-08-02 17:01:10 PST
From: Jerry Irons <JIrons@compuserve.com>
Newsgroups: borland.public.cppbuilder.database.ado
Subject: Re: ado Query DateTime Problem
Date: Fri, 02 Aug 2002 19:46:33 -0400
Message-ID: <r36mku86r9am428miqkmod4v68uflosg7l@4ax.com>
References: <3D463F31.674E9603@wasner.com>
X-Newsreader: Forte Agent 1.91/32.564
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
NNTP-Posting-Host: 24.54.9.179
X-Trace: dnews 1028332051 24.54.9.179 (2 Aug 2002 16:47:31 -0700)
Lines: 14
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-05!sn-xit-06!sn-xit-04!supernews.com!news.maxwell.syr.edu!nntp-relay.ihug.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews!not-for-mail

Reply to Parent Message