<html><head><style type="text/css"><!-- DIV {margin:0px;} --></style></head><body><div style="font-family:verdana,helvetica,sans-serif;font-size:10pt"><div>Hi Osvaldo.<br><br>This was working with UIB and fpc 2.2.0.<br>When change to fpc 2.2.2 the UIB 2.1 don't work anymore.<br><br>I've tried the svn version of UIB, but i can't make it compile. Because it, i began to try the sqldb an zeoslib (with just a "new" stable release..)<br><br>Thanks!!. Eduardo.<br><br><br></div><div style="font-family: verdana,helvetica,sans-serif; font-size: 10pt;"><br><div style="font-family: times new roman,new york,times,serif; font-size: 12pt;">----- Mensaje original ----<br>De: Osvaldo Filho <arquivostcf@gmail.com><br>Para: General mailing list <lazarus@lazarus.freepascal.org><br>Enviado: martes 19 de agosto de 2008, 10:30:59<br>Asunto: Re: [Lazarus] Problem working with Params in TSQLQuery<br><br><div dir="ltr">try UIB + FBDataset. Is very, very
good.<br><br><div class="gmail_quote">2008/8/18 Eduardo Lopez <span dir="ltr"><<a rel="nofollow" ymailto="mailto:dar_alle@yahoo.com.ar" target="_blank" href="mailto:dar_alle@yahoo.com.ar">dar_alle@yahoo.com.ar</a>></span><br><blockquote class="gmail_quote" style="border-left: 1px solid rgb(204, 204, 204); margin: 0pt 0pt 0pt 0.8ex; padding-left: 1ex;">
The scenario:<br>
<br>
Lazarus 0.9.25 svn: 16095M<br>
fpc 2.2.2<br>
Ubuntu 8.04 GTK2<br>
SQLDb components<br>
TIBConnection<br>
<br>
The following query works well:<br>
<br>
qry02.SQL.Clear;<br>
qry02.SQL.Text:= 'select PASSWOR from USUARIOS where CODUSU = ' +<br>
chr(39) + trim(pUsuario) + chr(39);<br>
trn02.Active:=true;<br>
qry02.Open;<br>
ContrasenaDB:=qry02.FieldByName('PASSWOR').AsString; // <--<br>
ContrasenaDB get the value from the query<br>
<br>
<br>
But this one don't get the value of 'PASSWOR':<br>
<br>
qry02.SQL.Clear;<br>
qry02.SQL.Text:= 'select PASSWOR from USUARIOS where CODUSU = :pCODUSU';<br>
qry02.Params.ParamByName('pCODUSU').AsString:= trim(pUsuario);<br>
trn02.Active:=true;<br>
qry02.Open;<br>
ContrasenaDB:=qry02.FieldByName('PASSWOR').AsString; // <---<br>
ContrasenaDB is empty<br>
<br>
(The second code was working with fpc 2.2.0 and the UIB components, with<br>
some changes. When upgrade to fpc 2.2.2 i began to replace de UIB with<br>
the default SQLDb componentes).<br>
<br>
TIA.<br>
<br>
Eduardo.<br>
<br>
<br>
<br>
_______________________________________________<br>
Lazarus mailing list<br>
<a rel="nofollow" ymailto="mailto:Lazarus@lazarus.freepascal.org" target="_blank" href="mailto:Lazarus@lazarus.freepascal.org">Lazarus@lazarus.freepascal.org</a><br>
<a rel="nofollow" target="_blank" href="http://www.lazarus.freepascal.org/mailman/listinfo/lazarus">http://www.lazarus.freepascal.org/mailman/listinfo/lazarus</a><br>
</blockquote></div><br></div>
</div></div></div><br>
<hr size=1><br><font face="Verdana" size="-2">¡Buscá desde tu celular!
Yahoo! oneSEARCH ahora está en Claro<br>
http://ar.mobile.yahoo.com/onesearch</font></body></html>