Page 1 of 1

Problem with query and parameters (D3 + IB + Zeos)

Posted: 18.02.2006, 17:08
by klandestyno
Hello people ..
I have a problem using parameters.
I am using Delphi 3 Standard with Zeos 5.4.1 Component and Firebird Database.

The code:
*****************************************
With TZIbSqlQuery Do
Begin
Close;
ParambyName('Name').AsString:= 'Value';
Open;
End;
*****************************************

The message error:

*****************************************
Parameter 'Name' not found
*****************************************

The ParamCheck property is False. This code found with IBDataSet component .. and others component, but I need to run whith Zeos.


Can anybody help-me?
Thanks

Posted: 18.02.2006, 19:29
by username

Code: Select all

With TZIbSqlQuery Do 
Begin 
Close; 
Params.CreateParam(ftString, 'Name', ptInputOutput);
ParambyName('Name').AsString:= 'Value'; 
Open; 
End;

Posted: 18.02.2006, 21:59
by klandestyno
Tnks

The app was running ..
But I receive the MessageError

Code: Select all

 
Column Unknown 
DATE 
Where 'DATE' is my parameter name.
[]'s