ADO with Oracle

From: Ulysses Neto (lissinho_at_sysplan.com.br)
Date: 05/24/04 

Date: Mon, 24 May 2004 17:51:57 -0300

Hi, everyone !!

  I've developed an application in Delphi 5 using ADO to access databases. I
choose ADO because it allow a single development of an application to access
a lot of databases (at least in theory). At this moment, my application can
access MS SQLServer or Access databases without problems. Now, I'm updating
it to be able to access Oracle databases too.
  My first big problem is that Oracle do not have the Integer datatype (I
use this type for my primary-keys). Is there a way to make changes in my
application WITHOUT changing SQLServer/Access schemas that work with these
three databases types ? I tried to inherited TIntegerField class and make a
change in its create procedure to change this field type when it is
accessing an Oracle database, but when I change the field class in the form
(viewing it as text) it gives me an access violation error.
  Can anyone help me with this ?

  Thanks for your attention.

Ulysses Neto.