Recent

Author Topic: query and mysql4.1  (Read 5529 times)

rodrigo

  • Guest
query and mysql4.1
« on: December 07, 2005, 02:03:13 am »
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

  • Administrator
  • Hero Member
  • *
  • Posts: 2590
RE: query and mysql4.1
« Reply #1 on: December 07, 2005, 11:32:05 am »
What it the definition of the SISTEMA table, what is the exact error message ?
//--
{$I stdsig.inc}
//-I still can't read someones mind
//-Bugs reported here will be forgotten. Use the bug tracker

rodrigo

  • Guest
definition of table SISTEMA
« Reply #2 on: December 07, 2005, 12:08:34 pm »
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

  • Hero Member
  • *****
  • Posts: 537
RE: definition of table SISTEMA
« Reply #3 on: December 07, 2005, 01:14:03 pm »
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.
What's in a sig? Would my posting look less if it didnot have a sig? (Free after William S.) :)

:( Why cannot I upload my own Avatar? :(

rodrigo

  • Guest
in mysqldb
« Reply #4 on: December 07, 2005, 01:48:42 pm »
I use mysqlclient4.1.... it may be the problem ? :?:

matthijs

  • Hero Member
  • *****
  • Posts: 537
RE: in mysqldb
« Reply #5 on: December 07, 2005, 05:13:23 pm »
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) :)
What's in a sig? Would my posting look less if it didnot have a sig? (Free after William S.) :)

:( Why cannot I upload my own Avatar? :(

 

TinyPortal © 2005-2018