 |
BorlandTalk.com
Borland discussion newsgroups
|
| View previous topic :: View next topic |
| Author |
Message |
Craig Stuntz [TeamB]
Guest
|
 Posted: Wed Nov 26, 2003 2:03 pm Post subject: Re: Parameters |
 |
|
Oldrich Masek wrote:
| Quote: | BUT, I'm getting an error, that the parameter was not found!
|
The first thing I'd suggest is to try a TSQLDataset, TDatasetProvider,
and TClientDataset instead of TSQLClientDataset. The latter component
is buggy and deprecated.
-Craig
--
Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH
Delphi/InterBase Weblog : http://delphi.weblogs.com
InterBase PLANalyzer 1.1 -- Free InterBase query optimization
tool: http://delphi.weblogs.com/IBPLANalyzer
|
|
| Back to top |
|
 |
Oldrich Masek
Guest
|
| Posted: Wed Nov 26, 2003 2:04 pm Post subject: Parameters |
|
|
Hi to all,
I would like to do something like this:
SQLClientDataSet1->CommandType = ctQuery;
SQLClientDataSet1->CommandText = "Select * from Accounts where
AccountID=:AI";
SQLClientDataSet1->Params->ParamByName("AI")->AsString = "26100";
SQLClientDataSet1->Active = true;
BUT, I'm getting an error, that the parameter was not found!
This worked with the BDE components,
does anybody have an idea where is the problem?
thanks
oldrich
|
|
| Back to top |
|
|
Oldrich Masek
Guest
|
| Posted: Thu Nov 27, 2003 10:52 am Post subject: Re: Parameters |
|
|
Thank you for the advice,
but I can not believe tahat Borland would release something so much broken.
There must be other an explination, maybe I have to introduce the parameter
first, or something.......
anybody?
thnaks
Oldrich
"Craig Stuntz [TeamB]" <cstuntz (AT) nospam (DOT) please [a.k.a. vertexsoftware.com]>
schrieb im Newsbeitrag news:3fc4c0a7$1 (AT) newsgroups (DOT) borland.com...
| Quote: | Oldrich Masek wrote:
BUT, I'm getting an error, that the parameter was not found!
The first thing I'd suggest is to try a TSQLDataset, TDatasetProvider,
and TClientDataset instead of TSQLClientDataset. The latter component
is buggy and deprecated.
-Craig
--
Craig Stuntz [TeamB] . Vertex Systems Corp. . Columbus, OH
Delphi/InterBase Weblog : http://delphi.weblogs.com
InterBase PLANalyzer 1.1 -- Free InterBase query optimization
tool: http://delphi.weblogs.com/IBPLANalyzer
|
|
|
| Back to top |
|
|
Bill Todd
Guest
|
| Posted: Thu Nov 27, 2003 1:27 pm Post subject: Re: Parameters |
|
|
On Thu, 27 Nov 2003 11:52:49 +0100, "Oldrich Masek"
<oldrich.masek (AT) easetec (DOT) de> wrote:
| Quote: | I can not believe tahat Borland would release something so much broken.
|
Believe it. This was something that was introduced very late in the
development cycle and the limitations were not obvious until after the
product shipped. That is the reason that the SQLClientDataSet has been
deprecated and is not included in later versions of Delphi.
As Craig said, change to separate components.
--
Bill (TeamB)
(TeamB cannot respond to questions received via email)
|
|
| Back to top |
|
|
|
|
You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot vote in polls in this forum
|
|
FAQ
Search
Memberlist
Usergroups
Register
Profile
Log in to check your private messages
Log in
