Devart Forums

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

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

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

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