Zeoslib Portal

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

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

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