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
tinyint value of field not correctly
Re: tinyint value of field not correctly
To reproduce the issue, specify UniDAC version, Delphi version, what DBMS you are using, as well as the script to create the Document table.
Re: tinyint value of field not correctly
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
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
Re: tinyint value of field not correctly
Thank you for the information. We have reproduced this issue and fixed it. This fix will be included in the next UniDAC build.