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

[Hayward, Phillip]

Thanks for that Edward.
Yes we are working through the BDE. Went and checked and yes you were
right, BCD had been disabled.
Problem solved.


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


-----Original Message-----
From: Edward Koryagin [mailto:ed_iv2001 at yahoo.co.nz] 
Sent: Wednesday, 14 June 2006 1:56 p.m.
To: NZ Borland Developers Group - Delphi List
Subject: Re: [DUG] Type mismatch - expecting: BCD actual: Integer

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

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.