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

Forum related to Firebird

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
klandestyno
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 18.02.2006, 03:29

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

Post 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
username
Fresh Boarder
Fresh Boarder
Posts: 5
Joined: 12.10.2005, 15:00
Location: Bolivia

Post by username »

Code: Select all

With TZIbSqlQuery Do 
Begin 
Close; 
Params.CreateParam(ftString, 'Name', ptInputOutput);
ParambyName('Name').AsString:= 'Value'; 
Open; 
End;
klandestyno
Fresh Boarder
Fresh Boarder
Posts: 2
Joined: 18.02.2006, 03:29

Post 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
Post Reply