Zeos problem with data type bigint in MSSQL

Forum related to version 6.5.1 (alpha) and 6.6.x (beta) of ZeosLib's DBOs

Moderators: gto, cipto_kh, EgonHugeist

Post Reply
indiralanza
Fresh Boarder
Fresh Boarder
Posts: 1
Joined: 12.07.2007, 16:56

Zeos problem with data type bigint in MSSQL

Post by indiralanza »

Hello

I am using the same Data Module(DM) to connect to MySQL and MSSQL 2000 Data Base (DB). I am using a TZTable to get data form both DB. The table I use in MSSQL and MYSQL has a fiel named IDCod and the type is "bigint".
When I add to my TZTable the field IDCod from MSSQL 2000 DB I get a "TFloatField" instead "TLargeintField" Why its happening if I have a bigint declared in my DB's table??????
When I connect to MySQL there is no problem because when the TZTable load the type of the field correctly as "TLargeintField" as in my table is declare as "bigint"
What can I do to solve this problem I need to use the same type of data "TLargeintField" for both DB because I use the same componencts of DM for Both.
Please wirte back soon. I will apreciate your help
Thanks
Indira :?
tweidelt
Fresh Boarder
Fresh Boarder
Posts: 3
Joined: 11.08.2007, 00:25

Post by tweidelt »

Please do a bug report at:
> http://zeosbugs.firmos.at/
User avatar
mdaems
Zeos Project Manager
Zeos Project Manager
Posts: 2766
Joined: 20.09.2005, 15:28
Location: Brussels, Belgium
Contact:

Post by mdaems »

It's already on the list. http://zeosbugs.firmos.at/view.php?id=54
When you read this post you may use the workaround mentioned there.

Unfortunately, I think we will need a community member using MSSQL to debug this error. For the moment I know no MSSQL members in the dev team...

Mark
Post Reply