Re: ADO Data type mismatch

Matthew wrote:

Hi

I am converting a application that was using BDE to an application
that uses ADO. Whenever the application encounters a field of type
float it raises an exception "data type mistmatch expecting float
found integer". The field is already a float. I had read the Enable
BCD should be turned OFF which I have done and I still get this error.

Does anyone know how to resolve this problem


when does this happen? on connecting to the database? On accessing a
single field?

--
Best regards :)

Guillem Vicens Meier
Dep. Informatica Green Service S.A.
www.clubgreenoasis.com
--
Contribute to the Indy Docs project: http://docs.indyproject.org
--
In order to contact me remove the -nospam

.

Relevant Pages

  • ADO Data type mismatch
    ... Whenever the application encounters a field of type float it raises an ... exception "data type mistmatch expecting float found integer". ... ICQ#: 43123296 Current ICQ status: + More ways to contact me ...
    (borland.public.delphi.database.ado)
  • Re: i know its a floating-point imprecision...
    ... i'm using float to store a fixed point exchange rate. ... So i was trying to go past Delphi's ADO wrapper and into ADO and it's ... And while checking how ADO handles floats and decimals, ... >> I understand that the value is stored in SQL Server using floating ...
    (microsoft.public.sqlserver.server)
  • Re: ADO Data type mismatch
    ... exception "data type mistmatch expecting float found integer". ... You have the field defined as a Tfloat using persistent fields but ADO seems to ... The Enable BCD setting here should not be a factor. ...
    (borland.public.delphi.database.ado)
  • Creating .csv file with ADO
    ... comopnent I am using is Zeos). ... Now I want to change to ADO and create a ... .CSV file with an SQL CREATE TABLE statement. ... `Likelihood` float NOT NULL, ...
    (borland.public.delphi.database.ado)