Loading wrong data type in the table

[gleickson]

Dear friends .. I am reading a Firebird database with the Zeos components .. but in ZTable component, numerc fields (15.2) are being loaded as TIntegerField. Very strange, since when do the same thing with DBExpress components kinds of fields is correct . I'm using Delphi 7 and Zeos 7.1.4 stable.
(Sorry for my bad english rs)

thank you!

[marsupilami]

Hello gleickson,

which version of Firebird do you use? Can you try the latest 7.1-version from SVN? You can check it out or export it from svn://svn.code.sf.net/p/zeoslib/code-0/branches/7.1-patches.

In my test environment (Delphi 7, Zeos-7.1-patches from SVN, Firebird 2.5.1) the following table

Code: Select all

create table test (
  id integer not null,
  testfield numeric(15,2)
)

loads as expected with id being a TIntegerField and testfield being a TFloatField.

With best regards,

Jan

[neodarkman]

Hi ...
I'm having a similar problem.
In a sqlite3 database have several columns of type REAL.
Some, Zeos, returns as the TStringField type, other TFloatField.
Must all be returned as TFloatField.

Zeos: 7.1.4
FPC: 2.6.4
Lazarus: 1.2.6

thanks