Zeoslib Portal

I have downloaded latest snapshot (zeoslib-code-0-r6503-branches-testing-7.3.zip) and tested under Delphi 2009 and XE.

Unfortunately, I don't see any improvement. The problem described in the first post is still present.

I have 'OVER' as the column name in several database tables and it creates problems with MariaDB, since it is a keyword in newer versions. I know where to make a change in ZEOS source but I wonder if there is a way to solve the problem in the application code? (MariaDb 10.4.12, Zeos 7.3 latest, Delp...

This is a valid query in Firebird/Flame Robin (and some other databases/managers) but Zeos reports an error:

select id, '' as ERROR_WITH_ZEOS from some_table

SQL Error: Incorrect values within SQLDA structure; empty pointer to data; at SQLVAR index 1.

(Firebird 3, Zeos 7.3 latest, Delphi 2009)

Steps to reproduce: 1. Put ZConnection, ZTable, Datasource, DBGrid on the form an connect everything 2. Open Fields Editor for ZTable and add one field but NOT THE FIRST DbGrid now shows content of the first column in the table instead of column defined in Fields Editor (Zeos 7.3 r6495, Delphi 2009,...

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 ...

OK Jan... I'll wait until you finish that before sending implementation of numeric/decimal to TBCDField mapping for Firebird.

My messages still waiting on approval or the server swallowed them... Really frustrating system you have here.

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...

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...

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...

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...