Parameter question

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

Article #694

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

#694

From: Pieter
Date: Mon, 11 Jul 2005 16:09

19 lines
1243 bytes

  Hi,

I use the following code:

String SQL = "PARAMETERS name Text(255);"
SQL += "SELECT ID FROM tblClient WHERE clientName = name";
qry->SQL->Clear();
qry->SQL->Add(SQL);
qry->Parameters->ParamByName("name") = "Test";

qry->ExecSQL();

When I execute this code I get the following error:
Parameter 'name' not found

What I am doing wrong?

Thanks in advance

Technical Details

Message-ID: <42d299b9$1@newsgroups.borland.com>

Path:

arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news2.google.com!proxad.net!212.101.4.254.MISMATCH!solnet.ch!solnet.ch!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail

Show Full Headers

Complete Article Headers

X-Google-Thread: 10698b,86b1cc438e982add,start
X-Google-Attributes: gid10698b,public
X-Google-Language: ENGLISH,ASCII-7-bit
From: "Pieter" <pieter@nomail.com>
Sender: "Pieter" <pieter@nomail.com>
Reply-To: "Pieter" <pieter@nomail.com>
Subject: Parameter question
Newsgroups: borland.public.cppbuilder.database.ado
X-User-Info: 193.173.66.209     
X-Forwarded-For: 172.21.152.243, 172.21.0.161
NNTP-Posting-Host: 207.105.83.66
Message-ID: <42d299b9$1@newsgroups.borland.com>
Date: 11 Jul 2005 09:09:29 -0700
X-Trace: newsgroups.borland.com 1121098169 207.105.83.66 (11 Jul 2005 09:09:29 -0700)
Lines: 20
Path: arc1-ca.pugleaf.net!g2news1.google.com!news4.google.com!news2.google.com!proxad.net!212.101.4.254.MISMATCH!solnet.ch!solnet.ch!news-out.newsgroups.com!propagator2-sterling.newsfeeds.com!in.nntp.be!caladan.landsraad.net!newsgroups.borland.com!not-for-mail