Article View: borland.public.cppbuilder.database.multi-tier
Article #330Problems with empty string parameters
From: Max Naud�
Date: Mon, 11 Feb 2002 10:31
Date: Mon, 11 Feb 2002 10:31
33 lines
1944 bytes
1944 bytes
Hi,
I get the following whenever I try to send an empty string parameter to a
stored procedure using TClientDataSet and TSocketConnection (with the help
of Borland SocketServer) :
ClientDataSet1->FetchParams();
ClientDataSet1->Params->ParamByName("@aDescription")->AsString =
frmSearch->edtDescription->Text;
ClientDataSet1->Execute();
When the Execute() is called the following exception is raised on the client
application EOleException with message "Parameter object is improperly
defined. Inconsistent or incomplete information was provided".
All works fine as long as no empty parameters are sent. Any idea for a
possible solution?
This is obviously occuring on the application server side
(TDataSetProvider). Why?
--
Max Naud�
Scope Technologies
Define Your Own Path To Mobile Solutions
~
This E-mail and any attached files transmitted with it are confidential and
the sole property of Scope Technologies Holdings Ltd. and are for the
exclusive use of the intended recipients
Technical Details
Message-ID:
<3c679d87_2@dnews>Path:
arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!isdnet!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnewsShow Full Headers
Complete Article Headers
X-Google-Language: ENGLISH,ASCII X-Google-Thread: fcd2b,4de74824ffaf6bce,start X-Google-Attributes: gidfcd2b,public X-Google-ArrivalTime: 2002-02-11 02:39:18 PST Reply-To: "Max Naud�" <max@scopetechnology.com> From: "Max Naud�" <max@scopetechnology.com> Newsgroups: borland.public.cppbuilder.database.multi-tier Subject: Problems with empty string parameters Date: Mon, 11 Feb 2002 12:31:20 +0200 Lines: 35 Organization: Scope Technologies 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: 196.25.126.136 Message-ID: <3c679d87_2@dnews> X-Trace: dnews 1013423495 196.25.126.136 (11 Feb 2002 02:31:35 -0800) Path: arc1-ca.pugleaf.net!archiver1.google.com!news1.google.com!sn-xit-02!supernews.com!isdnet!fr.clara.net!heighliner.fr.clara.net!newsfeed01.sul.t-online.de!t-online.de!dnews