Recent

Author Topic: MySQL + unsignedInt  (Read 3554 times)

Dets

  • Newbie
  • Posts: 1
MySQL + unsignedInt
« on: September 25, 2007, 12:04:23 pm »
I'm using a TMySQL50Connection with a TSQLQuery under Lazarus 0.9.22b to read a table containing an unsignedInt-Field. When the field contains a value greater than app. 2100000000, TSQLQuery.Open returns an EConvertError ("xxx is an invalid integer") instead of returning a negative value. How can I fix that without changing the field in the database?

BTW, using TODBCConnection works fine, but I'd like to use TMySQL50Connection because my program should run under Linux later.

thx, Dets ...

 

TinyPortal © 2005-2018