Page 1 of 1
Loading wrong data type in the table
Posted: 12.02.2015, 18:48
by 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!
Re: Loading wrong data type in the table
Posted: 16.02.2015, 18:39
by 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
Re: Loading wrong data type in the table
Posted: 28.04.2015, 19:43
by 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