[Lazarus] Problem working with Params in TSQLQuery

[Eduardo Lopez]

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.

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



      ____________________________________________________________________________________
¡Buscá desde tu celular!

Yahoo! oneSEARCH ahora está en Claro

http://ar.mobile.yahoo.com/onesearch
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://lists.lazarus-ide.org/pipermail/lazarus/attachments/20080819/abd1a344/attachment-0007.html>