Zquery have problem when passing parameter
Posted: 18.02.2013, 10:06
Hi,
I have facing a problem on XE2 with zquery, the coding as below:
zquery1.Active:=false;
zquery1.SQL.Clear;
zquery1.SQL.Add('select * from employee_master where employeeno=:p1');
zquery1.ParamByName('p1').value:='ST001';
zquery1.Active:=true;
The runtime error comes out Zquery1 : Parameter p1 not found.
The above coding under Delphi 6,7 with Zeoslib 6.6 is ok, but now have error, please help, thanks
**remark : development is under Window XP with service pack 3**
I have facing a problem on XE2 with zquery, the coding as below:
zquery1.Active:=false;
zquery1.SQL.Clear;
zquery1.SQL.Add('select * from employee_master where employeeno=:p1');
zquery1.ParamByName('p1').value:='ST001';
zquery1.Active:=true;
The runtime error comes out Zquery1 : Parameter p1 not found.
The above coding under Delphi 6,7 with Zeoslib 6.6 is ok, but now have error, please help, thanks
**remark : development is under Window XP with service pack 3**