Re: How to add date into TADOQuery

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

Article #2562

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

#2562

From: John Z Fields
Date: Tue, 27 May 2003 15:05

27 lines
1751 bytes

         U can assign to a field object as so....
the problem is a type mismatch. Date() is prob a TDateTime, and I it looks
like the ftDataType of Mname is not...


            GenericTableObjPtr->GetFieldObject(x)->AsDateTime =
 DateTimePickerPtrs[ControlCountersStruct.DateTimeUsed]-> DateTime ;


-- 
JOHN FIELDS
"Ken" <ken@kjfriends.com> wrote in message
news:3ebfc0fb$1@newsgroups.borland.com...
> Hi,
>
> Can anyone show me how assign value into a TADOQuery statement.
>
> TADOQuery->Parameters->ParamByName("Mname")->Value = Date();
>
> This statement cannot work, what is the correct way of assigning a date
> value into this statement.
>
> Thanks and best regards
>
> Ken
>
>

Technical Details

Message-ID: <3ed37ea7$1@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!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

References: <3ebfc0fb$1@newsgroups.borland.com>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,6f2909e7d1f5a04f
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2003-05-27 08:09:46 PST
Reply-To: "John Z Fields" <jfields@wrsystems.com>
From: "John Z Fields" <jfields@wrsystems.com>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3ebfc0fb$1@newsgroups.borland.com>
Subject: Re: How to add date into TADOQuery
Date: Tue, 27 May 2003 11:05:09 -0400
Lines: 29
Organization: WR Systems
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 6.00.2800.1158
X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2800.1165
NNTP-Posting-Host: 63.90.140.53
Message-ID: <3ed37ea7$1@newsgroups.borland.com>
X-Trace: newsgroups.borland.com 1054047911 63.90.140.53 (27 May 2003 08:05:11 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-08!supernews.com!news.tele.dk!news.tele.dk!small.news.tele.dk!eusc.inter.net!newsfeed01.sul.t-online.de!t-online.de!newsgroups.borland.com!not-for-mail

Reply to Parent Message