request data by CommandText with Param

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

Article #571

Back to borland.public.cppbuilder.database.multi-tier Previous Next

#571

From: Emmanuel
Date: Sun, 11 Mar 2001 17:05

24 lines
1427 bytes

I have try to request data by CommandText
"Select * from table1 where field1=:field1"
If there are some param
ClientDataSet->Close();
ClientDataSet->CommandText="Select * from table1 where field1=:field1"
ClientDataSet->Params->ParamByName("field1")->AsString="123";
ClientDataSet->Open();
there should be some data, but I find that the result is empty
If I write param directly to CommandText
"Select * from table1 where field1='ABC' "
there will be no problem

Please Help.

--
Emmanuel Li


---------------------------
ERP System Consultant
URL: http://www.erphk.com
E-mail: emmanuel@erphk.com
Tel: 2191 6116
Fax: 2191 6774

Technical Details

Message-ID: <3aabaef5$1_1@dnews>

Path:

arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!dnews!202.65.201.9

Show Full Headers

Complete Article Headers

X-Google-Language: ENGLISH,ASCII-7-bit
X-Google-Thread: fcd2b,d8b3281c5d6d6e4d,start
X-Google-Attributes: gidfcd2b,public
X-Google-ArrivalTime: 2001-03-11 09:06:05 PST
From: "Emmanuel" <emmanuel@erphk.com>
Newsgroups: borland.public.cppbuilder.database.multi-tier
Subject: request data by CommandText with Param
Date: Mon, 12 Mar 2001 01:05:40 +0800
Lines: 26
X-Priority: 3
X-MSMail-Priority: Normal
X-Newsreader: Microsoft Outlook Express 5.50.4133.2400
X-MimeOLE: Produced By Microsoft MimeOLE V5.50.4133.2400
NNTP-Posting-Host: 202.65.201.9
Message-ID: <3aabaef5$1_1@dnews>
X-Trace: 11 Mar 2001 08:59:33 -0800, 202.65.201.9
Path: arc1-ca.pugleaf.net!supernews.google.com!sn-xit-03!supernews.com!newsfeed.wirehub.nl!PeerFeed.KWeb.on.ca!bornews.borland.com!dnews!202.65.201.9