tinyint value of field not correctly

Discussion of open issues, suggestions and bugs regarding UniDAC (Universal Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
yar
Posts: 15
Joined: Sun 23 Mar 2014 10:47

tinyint value of field not correctly

Post by yar » Tue 07 Nov 2017 12:15

I run SQL by use component TUniQtuery
Select PaymentType from Document
Type field PaymentType - tinyint
Sometimes I get value of field not correctly
For example. instead 5 - -1000. instead 4 15000

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: tinyint value of field not correctly

Post by Stellar » Wed 15 Nov 2017 07:23

To reproduce the issue, specify UniDAC version, Delphi version, what DBMS you are using, as well as the script to create the Document table.

yar
Posts: 15
Joined: Sun 23 Mar 2014 10:47

Re: tinyint value of field not correctly

Post by yar » Mon 27 Nov 2017 16:37

Ttrial UniDAC 7.0.1
Delphi 7.0 Build 4.453
DB.SQL Anywhere 11

CREATE TABLE "DBA"."Document" (
"RecID" numeric(8,0) NOT NULL DEFAULT autoincrement
,"snPaymentType" tinyint NULL
,"dPayDate" "datetime" NULL
,PRIMARY KEY ("RecID" ASC)
)
go

Stellar
Devart Team
Posts: 496
Joined: Tue 03 Oct 2017 11:00

Re: tinyint value of field not correctly

Post by Stellar » Thu 30 Nov 2017 11:05

Thank you for the information. We have reproduced this issue and fixed it. This fix will be included in the next UniDAC build.

Post Reply