Re: Empty String Parameters are Illegal in ADO?

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

Article #5188

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

#5188

From: Alon Novy
Date: Fri, 29 Jun 2001 09:07

26 lines
1821 bytes

Arnie

Does the same happen if you try:
    q->Parameters->ParamByName( "foo" )->Value = Null;        // note: using
Null variable, not c/c++ NULL value

or alternatively:
    q->Parameters->ParamByName( "foo" )->Value = Variant( );

???

Alon

"Arnie Mauer" <arnie@marketexpert.com> wrote in message
news:3b20ed67_2@dnews...
> In a parameterized INSERT statement in a TADOQuery, when setting
> q->Parameters->ParamByName( "foo" )->Value = "";
> will cause q->ExecSQL() to throw an excpetion of: "Parameter object is
> improperly defined.  Inconsistent or incomplete information
> was provided."  Same goes for a NULL AnsiString.
>
> The TParameter Value == NULL and Length == 0.  The DataType
> has been properly set to ftString after the assignment.  What's
> wrong with a NULL string?
>
>

Technical Details

Message-ID: <3b3c42a6$2_1@dnews>

Path:

arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!intgwpad.nntp.telstra.net!intgwlon.nntp.telstra.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

References: <3b20ed67_2@dnews>

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: 10698b,bf8db65ec424c3c9
X-Google-Attributes: gid10698b,public
X-Google-ArrivalTime: 2001-06-29 02:02:47 PST
Reply-To: "Alon Novy" <alon.novy@thinksoftware.com.au>
From: "Alon Novy" <alon.novy@thinksoftware.com.au>
Newsgroups: borland.public.cppbuilder.database.ado
References: <3b20ed67_2@dnews>
Subject: Re: Empty String Parameters are Illegal in ADO?
Date: Fri, 29 Jun 2001 19:07:17 +1000
Lines: 28
Organization: Think Software
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.00.2919.6700
X-MimeOLE: Produced By Microsoft MimeOLE V5.00.2919.6700
NNTP-Posting-Host: 203.32.175.13
Message-ID: <3b3c42a6$2_1@dnews>
X-Trace: dnews 993804966 203.32.175.13 (29 Jun 2001 01:56:06 -0700)
Path: arc1-ca.pugleaf.net!archiver1.google.com!newsfeed.google.com!sn-xit-02!supernews.com!newsfeed.direct.ca!look.ca!news.maxwell.syr.edu!intgwpad.nntp.telstra.net!intgwlon.nntp.telstra.net!newsfeeds.ihug.co.nz!ihug.co.nz!dnews

Reply to Parent Message