🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

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

Re: How to put NULL into TParameter?

#3611
From: Pedja
Date: Thu, 18 Jul 2002 14:51
42 lines
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!dnews
References: <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