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

Edward Koryagin ed_iv2001 at yahoo.co.nz
Wed Jun 14 13:56:20 NZST 2006


Why not IBDatabaseError?
Do you work with database through BDE?
BDE
Admin/Configuration/Drivers/Native/Interbase/Enable
BCD
--- "Hayward, Phillip" <Phillip.Hayward at chh.co.nz>
wrote:

> 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.
> 
> _______________________________________________
> Delphi mailing list
> Delphi at ns3.123.co.nz
> http://ns3.123.co.nz/mailman/listinfo/delphi
> 


Edward Koryagin

Send instant messages to your online friends http://au.messenger.yahoo.com 


More information about the Delphi mailing list