query and mysql4.1
lazarus / 16-Databases

----------------------------------------------------------------------
rodrigo · 2005-12-07 01:03

All times that try query: SELECT sNome,sDescricao FROM SISTEMA WHERE
iCodigo, the lazarus return this error: EConvertError with
'....e....E..' is an invalid float. How remove this error ? Any Idea ?

----------------------------------------------------------------------
Marc · 2005-12-07 10:32

What it the definition of the SISTEMA table, what is the exact error
message ?

----------------------------------------------------------------------
rodrigo · 2005-12-07 11:08

It is definition of table SISTEMA:
iCodigo int autoincremental
sNome  varchar(50) not null
sDescricao varchar(100) not null

I use it is query: SELECT sNome,sDescricao FROM SISTEMA WHERE
iCodigo=1 and return the error before write.

Any idea of cause of error ? :?:

----------------------------------------------------------------------
matthijs · 2005-12-07 12:14

What client library are you using to connect to the mySQL server?
Which components are you using? Remember: The Lazarus SQLdb components
only work with mySQL client library 4.0.

----------------------------------------------------------------------
rodrigo · 2005-12-07 12:48

I use mysqlclient4.1.... it may be the problem ? :?:

----------------------------------------------------------------------
matthijs · 2005-12-07 16:13

Yes. That will most probably the problem. As I said the SQLdb
components only work with mysqlclient4.0
With this client you can also connect to mysql 4.1 servers (and 3.23)