[DUG] Type mismatch - expecting: BCD actual: Integer

[Hayward, Phillip]

Have an application that is working well in our production environment.
Set it up in the test environment to make some changes and get the
following error when attempting to run it.

Project Despatch_Gateway.exe raised exception EDatabaseError with
message 'tDeliveries: Type mismatch for field 'DELV_WEIGHT', expecting:
BCD actual: Integer;'

The database is Interbase 7.5.1 and is a copy of our production data.

The error is caused when the application attempts to open a TTable
(tDeliveries.Open;).
The field it is complaining about has been declared as a TBCDField
(tDeliveriesDELV_DATE: TDateTimeField;)
The correspending field in the table is  Numeric(9,3)

We are using the same code that was used and tested in this environment
only a matter of a few weeks ago and are not aware of any changes having
been made.

Has anyone experienced these issues or have any thoughts as to what may
be happening?


Regards 
Phil Hayward

System Analyst 
Pinepanels Rangiora
ph  (64) 3 313-2764
fax (64) 3 313-2739
Ext 38824
Phillip.Hayward at chh.co.nz


DISCLAIMER: This electronic message together with any attachments is 
confidential. If you are not the intended recipient, do not copy, disclose or 
use the contents in any way. Please also advise us by return e-mail that you 
have received the message and then please destroy. Carter Holt Harvey is not 
responsible for any changes made to this message and / or any attachments after 
sending by Carter Holt Harvey. We use virus scanning software but exclude all 
liability for viruses or anything similar in this email or any attachment.