Search found 7 matches

by abonic
24.03.2017, 12:12
Forum: ZeosLib 7.2 Betatest Forum
Topic: UncachedGetColumns and numeric/decimal
Replies: 13
Views: 400

Re: UncachedGetColumns and numeric/decimal

Hi Jan, I had a look into the problem with TFloatField and its precision. First of all TFloatField implements a field for double precision data types. So generally restricting its precision to 7 does't make sense. TFloatField is double but stFloat is single and only in that case Precision is set to ...
by abonic
21.03.2017, 11:13
Forum: ZeosLib 7.2 Betatest Forum
Topic: UncachedGetColumns and numeric/decimal
Replies: 13
Views: 400

Re: UncachedGetColumns and numeric/decimal

OK Jan... I'll wait until you finish that before sending implementation of numeric/decimal to TBCDField mapping for Firebird.
by abonic
16.03.2017, 10:47
Forum: ZeosLib 7.2 Betatest Forum
Topic: UncachedGetColumns and numeric/decimal
Replies: 13
Views: 400

Re: UncachedGetColumns and numeric/decimal

My messages still waiting on approval or the server swallowed them... :gruebel: Really frustrating system you have here.
by abonic
14.03.2017, 16:40
Forum: ZeosLib 7.2 Betatest Forum
Topic: UncachedGetColumns and numeric/decimal
Replies: 13
Views: 400

Re: UncachedGetColumns and numeric/decimal

Corrections from my previous post will fix the problem with float and small numeric, but not with decimal type. For some reason, decimal is always stBigDecimal and TExtendedField on Delphi side. (Numeric is TFloatField - why the difference?) To fix problems with decimal type, function TZSQLDA.GetFie...
by abonic
14.03.2017, 11:15
Forum: ZeosLib 7.2 Betatest Forum
Topic: UncachedGetColumns and numeric/decimal
Replies: 13
Views: 400

Re: UncachedGetColumns and numeric/decimal

If it works, it's fine by me. While we at numeric type, another, more important problem: This is how DBGrid displays some values of numeric(4,2) type: 00.10 -> 0.100000001490116 00.80 -> 0.800000011920929 99.99 -> 99.9899978637695 Display problem can be solved if we set Precision for each numeric co...
by abonic
10.03.2017, 16:38
Forum: ZeosLib 7.2 Betatest Forum
Topic: UncachedGetColumns and numeric/decimal
Replies: 13
Views: 400

UncachedGetColumns and numeric/decimal

BUG: function TZInterbase6DatabaseMetadata.UncachedGetColumns (from unit ZDbcInterbase6Metadata) recognize numeric/decimal columns only if the field is 8 bytes long. In other cases the column is reported as smallint or integer. TEST: procedure TForm1.GetMeta; var rs: IZResultSet; begin rs := ZConne...
by abonic
25.11.2016, 17:22
Forum: ZeosLib 7.2 Betatest Forum
Topic: ZEOS 7.2 and Firebird 3 Boolean fields
Replies: 1
Views: 206

ZEOS 7.2 and Firebird 3 Boolean fields

ZEOS 7.2.1-rc do not work with Firebird 3 Boolean fields because of error in ZDbcInterbase6Utils.pas procedure TZSQLDA.InitFields(Parameters: boolean); Here is the fix: case SqlVar.sqltype and (not 1) of { bug fix start } SQL_BOOLEAN_FB, // it works now { bug fix end } SQL_BOOLEAN, SQL_TEXT, SQL_TYP...

Go to advanced search