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?
Type mismatch for field 'xx' expecting: Float actual Extended
- EgonHugeist
- Zeos Project Manager
- Posts: 1936
- Joined: 31.03.2011, 22:38
Re: Type mismatch for field 'xx' expecting: Float actual Extended
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
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
Best regards, Michael
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
![Image](https://www.ohloh.net/accounts/146511/widgets/account_detailed.gif)
You want to help? http://zeoslib.sourceforge.net/viewtopic.php?f=4&t=3671
You found a (possible) bug? Use the new bugtracker dude! http://sourceforge.net/p/zeoslib/tickets/
![Image](https://www.ohloh.net/accounts/146511/widgets/account_detailed.gif)
-
- Platinum Boarder
- Posts: 1928
- Joined: 17.01.2011, 14:17
Re: Type mismatch for field 'xx' expecting: Float actual Extended
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![wink ;)](./images/smilies/icon_wink.gif)
Best regards,
Jan
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
![wink ;)](./images/smilies/icon_wink.gif)
Best regards,
Jan
Re: Type mismatch for field 'xx' expecting: Float actual Extended
when I remove it and readd it will stay same type TFloatField ... we had to revert it, i'll check it again this week
Re: Type mismatch for field 'xx' expecting: Float actual Extended
Have a look for this topic http://zeoslib.sourceforge.net/viewtopi ... 40&t=92611.DPStano wrote:when I remove it and readd it will stay same type TFloatField ... we had to revert it, i'll check it again this week
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.
-
- Platinum Boarder
- Posts: 1928
- Joined: 17.01.2011, 14:17
Re: Type mismatch for field 'xx' expecting: Float actual Extended
Hello DPStano,
could you please check if the current Zeos-7.2-testing branch on SVN solves your problem?
Best regards,
Jan
could you please check if the current Zeos-7.2-testing branch on SVN solves your problem?
Best regards,
Jan