ZQuery1.SQL.Text := 'select * from fpusers where username=:wuser';
ZQuery1.Prepare;
ZQuery1.ParamByName('wuser').asString := Edit1.Text;
ZQuery1.Open;
make an error
ZQuery1.SQL.Text := 'select * from fpusers where username=:wuser';
ZQuery1.Prepare;
ZQuery1.ParamByName('wuser').value := Edit1.Text;
ZQuery1.Open;
This syntaxe is Ok
How to resolve this problem
thank you for help
[bug_fixed] Problem With ParambyName('workingvar').asString
Moderators: gto, EgonHugeist, olehs
- mdaems
- Zeos Project Manager
- Posts: 2766
- Joined: 20.09.2005, 15:28
- Location: Brussels, Belgium
- Contact:
Hi,
Can you tell what the exact error is?
My impression is that the asString and edit1.text datatype don't match.
Can you tell what versions of Delphi and zeoslib (exact version: svn, snapshot or 7.0.0 release) your are using? When you're using the first release, please try again with a snapshot from http://zeosdownloads.firmos.at/downloads/snapshots . Testing or Trunk versions. Quite some changes to the code have happened since.
Mark
Can you tell what the exact error is?
My impression is that the asString and edit1.text datatype don't match.
Can you tell what versions of Delphi and zeoslib (exact version: svn, snapshot or 7.0.0 release) your are using? When you're using the first release, please try again with a snapshot from http://zeosdownloads.firmos.at/downloads/snapshots . Testing or Trunk versions. Quite some changes to the code have happened since.
Mark