Re: Delphi 5 <> ADO

"Paul Meyer" <greenmile27@xxxxxx> wrote in message
news:epl5rg$p78$00$1@xxxxxxxxxxxxxxxxxxxx
Hello NG,

i use ADO 2.8 in my Delphi 5 application to connect to SQL-Server 2000.
All
works fine, but now i've to support Oracle 9i. The ADO-Connection (.UDL)
works, but if i try to connect, my Delphi want "TAutoInc" field, but
Oracle
give me only float. Delphi want Boolean, but i Oracle give me a float.
Every
field Oracle gives, is a float. Is this an error into ADO, Oracle or
Delphi? Is there
short way to solve this problem or do i need to swith to other components
<>
ADO?

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.

I don't know of any 'automatic' way around it.

- Arnie


.

Relevant Pages

  • Re: Delphi 5 <> ADO
    ... Oracle only give float. ... I can't believe that this is an Delphi ... NUMBER is a float and it is the ONLY numerical data type. ...
    (borland.public.delphi.database.ado)
  • Re: Delphi bugs and "moving" to Visual Studio debate
    ... mention to them that Delphi is named Delphi because it was to ... development environment for Oracle, ... item 3 (database) is the primary factor for decisions. ... > clients don't even know about any bugs etc in IDE's before they decide ...
    (borland.public.delphi.non-technical)
  • Re: Reaction to Q2 Warning
    ... it doesn't have to run on anything but client machines connecting to an Oracle server. ... AFIAK, Sun doesn't sell a database so Delphi is pretty much useless for Sun. IMO, an acquisition by Sun has the highest likelihood of killing Delphi. ...
    (borland.public.delphi.non-technical)
  • Re: Delphi bugs and "moving" to Visual Studio debate
    ... Even the origins of the name Delphi ... " The strategic decision to make database tools and connectivity a central ... Gary kept coming back to the codename "Oracle", ... connectivity to Oracle servers. ...
    (borland.public.delphi.non-technical)
  • Re: Which version of D2005 do I need?
    ... > it's name in next release MSSQL Express Edition), Interbase, and MySQL. ... > Oracle, Interbase, and others you'll need the Enterprise Edition. ... I haven't checked this out yet, because both Delphi 2005, and RemObjects SDK ... one would be able to get the RAD database connectivity for Oracle, ...
    (borland.public.delphi.non-technical)