🚀 go-pugleaf

RetroBBS NetNews Server

Inspired by RockSolid Light RIP Retro Guy

Article View: borland.public.cppbuilder.database.multi-tier
Article #330

Problems with empty string parameters

#330
From: Max Naud�
Date: Mon, 11 Feb 2002 10:31
33 lines
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!dnews

Show 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