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 [EMAIL PROTECTED] -----Original Message----- From: Edward Koryagin [mailto:[EMAIL PROTECTED] 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" <[EMAIL PROTECTED]> 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 > [EMAIL PROTECTED] > > > 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 > [email protected] > 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 [email protected] 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. _______________________________________________ Delphi mailing list [email protected] http://ns3.123.co.nz/mailman/listinfo/delphi
