Re: Delphi 5 <> ADO

Paul, as another poster has noted you need to make all your TField componens
corresponding to numeric fields in Oracle a TFloatField. You may have
TAutoIncField, TIntegerField or TBooleanField in your application, but you
need to convert them to TNumericField for Oracle.

"Paul Meyer" <greenmile27@xxxxxx> ???????/???????? ? ???????? ?????????:
news:epn19l$su6$03$1@xxxxxxxxxxxxxxxxxxxx
My problem is: Delphi say "Boolean" required, but always only Float is
given. Oracle only give float. I can't believe that this is an Delphi
problem.

It's not ADO, it's Oracle.

It sounds like you are talking about persistent fields from your
description above. Oracle only has a few basic datatypes: CHAR,
VARCHAR2, NUMBER and DATE. Yes, there are also BLOBs and you can define
your own objects.

NUMBER is a float and it is the ONLY numerical data type. Therefore,
anything based on the NUMBER datatype will always return a field type of
TFloatField.




.

Relevant Pages

  • Error Linking/Importing Oracle Tables to Access 2003!
    ... I converted an Access97 database to Access 2003 and now I'm having ... The Links that I made to Oracle tables with the previous version ... seems to work well, the numeric fields that have decimal places, are shown ... and cancels the importation of the table!!! ...
    (microsoft.public.access.externaldata)
  • Re: Oracle Forms and special query operators
    ... means "fetch all the rows where this field is less than 3". ... numeric fields but the Forms engine doesn't seem to like it. ... I think the term you want to search is "query by example". ... word Oracle somewhere in your search. ...
    (comp.databases.oracle.tools)
  • Re: Delphi 5 <> ADO
    ... but now i've to support Oracle 9i. ... Delphi want Boolean, but i Oracle give me a float. ... NUMBER is a float and it is the ONLY numerical data type. ...
    (borland.public.delphi.database.ado)
  • Re: FieldByName
    ... TFloatField vs. TIntegerField with MS-SQL vs. Oracle). ...
    (borland.public.delphi.language.basm)