Article View: borland.public.cppbuilder.database.ado
Article #3611Re: How to put NULL into TParameter?
From: Pedja
Date: Thu, 18 Jul 2002 14:51
Date: Thu, 18 Jul 2002 14:51
42 lines
2147 bytes
2147 bytes
I tried that as well, only, instead of *(new Variant()), I put Variant().
It's still the same problem, after I execute the query, I receive error
message.
Thanks.
- Pedja.
"Georgi Cholakov" <georgi.cholakov@mail.bg> wrote in message
news:3d36a694_1@dnews...
>
> pQry->Parameters->ParamByName("DateRcvd")->Value = *(new Variant());
>
>
> "Pedja" <pgrkovic@hotmail.com> wrote in message news:3d3677b5_2@dnews...
> > Hello,
> > I have a problem specifying TParameter::Value to be NULL. I'm running
> > Borland C++ Builder 5 on Windows 2000 SP2.
> > I think I've tried everything I could think of. I always get the
message,
> on
> > ExecSQL:
> > "Parameter object is improperly defined. Inconsistent or incomplete
> > information was provided"
> >
> > ///////////////////////////////////////////////////////
> > Variant varDateRcvd;
> > varDateRcvd.ChangeType( varNull );
> > TParameterAttributes attrs;
> > attrs << paNullable;
> > pQry->Parameters->ParamByName("DateRcvd")->Attributes = attrs;
> > pQry->Parameters->ParamByName("DateRcvd")->Value = varDateRcvd;
> >
> > pQry->ExecSQL();
> > ///////////////////////////////////////////////////////
> >
> > Does anybody have any idea?
> > TIA.
> > - Pedja.
> >
> >
>
>
Technical Details
Message-ID:
<3d36d5f1_1@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-04!supernews.com!news.maxwell.syr.edu!nntp.infostrada.it!newsfeed01.sul.t-online.de!t-online.de!dnewsReferences:
<3d3677b5_2@dnews> <3d36a694_1@dnews>Show Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII-7-bit X-Google-Thread: 10698b,cc4e8136757a786e X-Google-Attributes: gid10698b,public X-Google-ArrivalTime: 2002-07-18 08:14:32 PST From: "Pedja" <pgrkovic@hotmail.com> Newsgroups: borland.public.cppbuilder.database.ado References: <3d3677b5_2@dnews> <3d36a694_1@dnews> Subject: Re: How to put NULL into TParameter? Date: Thu, 18 Jul 2002 17:51:29 +0300 Lines: 44 X-Priority: 3 X-MSMail-Priority: Normal X-Newsreader: Microsoft Outlook Express 6.00.2600.0000 X-MimeOLE: Produced By Microsoft MimeOLE V6.00.2600.0000 NNTP-Posting-Host: 212.31.100.26 Message-ID: <3d36d5f1_1@dnews> X-Trace: dnews 1027003889 212.31.100.26 (18 Jul 2002 07:51:29 -0700) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!sn-xit-06!sn-xit-04!supernews.com!news.maxwell.syr.edu!nntp.infostrada.it!newsfeed01.sul.t-online.de!t-online.de!dnews