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

[Edward Koryagin]

You are wellcome!
Regards,
Edward.
--- "Hayward, Phillip" <Phillip.Hayward at chh.co.nz>
wrote:

> 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.
> 
> _______________________________________________
> 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