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 Lazarus@lazarus.freepascal.org http://www.lazarus.freepascal.org/mailman/listinfo/lazarus