🚀 go-pugleaf

ParamByName recognizes parameters in form :paramName - select ID from 
tblClient where clientName = :name. Try qry->Parameters->Refresh() after 
assigning SQL, you may want to set ParamCheck = false if you do not use 
:paramName notation. BTW, your syntax is for MS Jet (MS Access) only.

//------------------------------------------
Regards,
Vassiliev V. V.
http://www.managed-vcl.com - using .Net objects in Delphi for Win32 + 
ADO.Net
http://www.oledbdirect.com - The fastest way to access MS SQL Server,
MS Jet (Access) and Interbase (through OLEDB)

"Pieter" <pieter@nomail.com> �������/�������� � �������� ���������: 
news:42d299b9$1@newsgroups.borland.com...
>
>  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
>