[bug_fixed] Problem With ParambyName('workingvar').asString

The alpha/beta tester's forum for ZeosLib 7.0.x series

Report problems concerning our Delphi 2009+ version and new Zeoslib 7.0 features here.

This is a forum that will be removed once the 7.X version goes into stable!!

Moderators: gto, EgonHugeist, olehs

Locked
User avatar
M56OBER
Fresh Boarder
Fresh Boarder
Posts: 20
Joined: 28.10.2005, 12:33
Location: FRANCE

[bug_fixed] Problem With ParambyName('workingvar').asString

Post by M56OBER »

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
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post by mdaems »

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
Image
User avatar
M56OBER
Fresh Boarder
Fresh Boarder
Posts: 20
Joined: 28.10.2005, 12:33
Location: FRANCE

Post by M56OBER »

Bonjour,

J'utilise Delphi 2010 Version 14.0.3593.25826
Je viens d'installer la dernière version ZEOSLIB_TRUNK_REV829

Le problème est résolu.

Cordialement
Olivier
Locked