type mismatch for field "customer" , Expecting: FMTBcdfield actual: integer

Discussion of open issues, suggestions and bugs regarding usage of dbExpress drivers for InterBase & Firebird in Delphi and C++Builder
Post Reply
evandroks
Posts: 7
Joined: Fri 07 Nov 2014 19:38

type mismatch for field "customer" , Expecting: FMTBcdfield actual: integer

Post by evandroks » Fri 07 Nov 2014 19:53

I had an application working fine in Delphi 2007

Then I reinstalled Delphi 2007
and installed dbexpress trial for Interbase & Firebird

A lot of forms are working,
but in some I have problems:

type mismatch for field "customer" , Expecting: FMTBcdfield actual: integer

How to fix this ?

ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: type mismatch for field "customer" , Expecting: FMTBcdfield actual: integer

Post by ViktorV » Mon 10 Nov 2014 09:21

Such error may occur when the scale and precision fields in the database don't correspond to the persistent field's type in the DataSet. Please, try to recreate persistent fields at design-time in Fields Editor in the DataSet. You can find more details in the Data Type Mapping article in Readme.html at: %DBXInterBase%\Readme.html where %DBXInterBase% is the path to the installed dbExpress driver for InterBase and Firebird.


ViktorV
Devart Team
Posts: 3168
Joined: Wed 30 Jul 2014 07:16

Re: type mismatch for field "customer" , Expecting: FMTBcdfield actual: integer

Post by ViktorV » Mon 10 Nov 2014 12:58

Feel free to contact us if you have any further questions.

Post Reply