[Lazarus] Problem working with Params in TSQLQuery

[Bogusław Brandys]

Eduardo Lopez pisze:
> 
> Yes!! It works now.!!
> 
> My challenge is now:
> 
> a) modify all my db structure or b) replace the sqldb components with zeos.
> 
> Thank you very much to all!!
> 
> Eduardo.


c) write padding function


:-)


> On Tue, 19 Aug 2008, Eduardo Lopez wrote:
> 
>  > I'm sorry. The table has a basic structure:
> 
> CREATE TABLE USUARIOS
> (
> CODUSU Char(12) NOT NULL,
> APENOMB Char(40) NOT NULL,
> PASSWOR Char(12) NOT NULL,
> CONSTRAINT PK_USUARIOS PRIMARY KEY (CODUSU)
> );
> 
> Aha.
> This is probably your problem. Try extending the parameter value
> so it has the declared length by padding it with spaces.
> 
> 
> The other way is to declare the table as
> CREATE TABLE USUARIOS
> (
> CODUSU VARChar(12) NOT NULL,
> APENOMB VarChar(40) NOT NULL,
> PASSWOR VarChar(12) NOT NULL,
> CONSTRAINT PK_USUARIOS PRIMARY KEY (CODUSU)
> );
> 
> Could you try this ?
> 
> Michael.
> _______________________________________________
> Lazarus mailing list
> Lazarus at lazarus.freepascal.org <mailto:Lazarus at lazarus.freepascal.org>
> http://www.lazarus.freepascal.org/mailman/listinfo/lazarus
> 
> 
> Yahoo! Cocina
> Recetas prácticas y comida saludable
> Visitá http://ar.mujer.yahoo.com/cocina/
> 
> 
> ------------------------------------------------------------------------
> 
> _______________________________________________
> Lazarus mailing list
> Lazarus at lazarus.freepascal.org
> http://www.lazarus.freepascal.org/mailman/listinfo/lazarus