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
Zeos problem with data type bigint in MSSQL
Moderators: gto, cipto_kh, EgonHugeist
-
- Fresh Boarder
- Posts: 1
- Joined: 12.07.2007, 16:56
Please do a bug report at:
> http://zeosbugs.firmos.at/
> http://zeosbugs.firmos.at/
- mdaems
- Zeos Project Manager
- Posts: 2766
- Joined: 20.09.2005, 15:28
- Location: Brussels, Belgium
- Contact:
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
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