Type mismatch for field 'xx' expecting: Float actual Extended

[DPStano]

after updating to current 7.2 patches I'm getting Type mismatch for field 'xx' expecting: Float actual Extended for all NUMERIC( 18, 4) fields Firebird 3.5

should I go back to stable version or fix these exceptions but how?

[EgonHugeist]

Hi,

i did a comparision of ZDbcInterbaseUtils.pas. Both functions (
TZSQLDA.GetFieldSqlType(Index: Word): TZSQLType
function ConvertInterbase6ToSqlType(SqlType, SqlSubType, Scale, Precision: Integer;
const CtrlsCPType: TZControlsCodePage): TZSqlType;
)
are binary equal. That type diff should not happen.

Could you please check if we're talking about:
FireBird
!7.2-patches! branch

[marsupilami]

Hello DPStano,

usually this happens when you have persistent fields in you application and Zeos decides to use another TField descandant for some fields in newer versions. Usually it is enough to remove your persistent fields and readd them - Or to decide to not use persistent Fields at all

Best regards,

Jan

[DPStano]

when I remove it and readd it will stay same type TFloatField ... we had to revert it, i'll check it again this week

[louis]

when I remove it and readd it will stay same type TFloatField ... we had to revert it, i'll check it again this week

Have a look for this topic http://zeoslib.sourceforge.net/viewtopi ... 40&t=92611.
I've got the same problem updating from Zeos 7.2.0b to 7.2.4-stable.

I get TFloatField in one query and TExtendedField in other query for the same field in the same table depending on writing query statements.

If I have a persistent TFloatField in a query that get TExtendedField i get Exception Type Mismatch...

Regards.

[marsupilami]

Hello DPStano,

could you please check if the current Zeos-7.2-testing branch on SVN solves your problem?
Best regards,

Jan