On Mon, 18 Aug 2008 02:01:14 -0300, Eduardo Lopez wrote:
>The following query works well:
>
> qry02.SQL.Clear;
> qry02.SQL.Text:= 'select PASSWOR from USUARIOS where CODUSU = ' +
>chr(39) + trim(pUsuario) + chr(39);
> trn02.Active:=true;
> qry02.Open;
> ContrasenaDB:=qry02.FieldByName('PASSWOR').AsString; // <--
>ContrasenaDB get the value from the query
>
>
>But this one don't get the value of 'PASSWOR':
>
> qry02.SQL.Clear;
> qry02.SQL.Text:= 'select PASSWOR from USUARIOS where CODUSU = :pCODUSU';
> qry02.Params.ParamByName('pCODUSU').AsString:= trim(pUsuario);
> trn02.Active:=true;
> qry02.Open;
> ContrasenaDB:=qry02.FieldByName('PASSWOR').AsString; // <---
>ContrasenaDB is empty
The first one has quotes around the data string you are comparing
against, has the second one got the quotes too when it's passed to the
database?
--
Regards - Rodney Pont
E-mail by PMMail - [EMAIL PROTECTED]
really weird out of context words courtesy of PMMail's spellchecker
_______________________________________________
Lazarus mailing list
[email protected]
http://www.lazarus.freepascal.org/mailman/listinfo/lazarus
