Board index » delphi » Oracle Datatypes vs TFields

Tomm

Delphi Developer
Tue, 19 Nov 2002 03:00:00 GMT

Oracle Datatypes vs TFields

How do I get a TIntegerField in a TADOQuery?

The fields are defined as Number(6) or Number(38)  in the Oracle database.
Delphi ADOExpress maps these to either TBCDField or TFloatField.
The app uses TIntegerField (runs with MSSQL and Access DB's as well)

I am using the Oracle OLE-DB Provider for Delphi 5 / ADOExpress and Oracle
8.0.5

- Tomm

 
Gary Jone

Delphi Developer
Sun, 01 Dec 2002 03:00:00 GMT

Re:Oracle Datatypes vs TFields


I am trying to find the answer also.  We've built a large Delphi app using Ado
with Sql Server and need to convert it to Oracle.  We need to support both
platforms, so I can't change all my field definitions to TBCDField.

Does anyone know of a solution?

Thanks,

Gary Jones

Quote
Tomm wrote:
> How do I get a TIntegerField in a TADOQuery?

> The fields are defined as Number(6) or Number(38)  in the Oracle database.
> Delphi ADOExpress maps these to either TBCDField or TFloatField.
> The app uses TIntegerField (runs with MSSQL and Access DB's as well)

> I am using the Oracle OLE-DB Provider for Delphi 5 / ADOExpress and Oracle
> 8.0.5

> - Tomm

Other Threads

1. ORACLE Union x TField.DataType

2. How to show TField.DataSize and Tfield.DataType???

3. MSSQL Image datatype VS. Paradox Graphics DataType

4. Delphi DataTypes vs Database datatypes

5. TField.DataType=??

6. TField.DataType property doesn't work properly

7. TField.DataType

8. Getting data from TField of datatype memo

9. DataTypes vs Speed: is there such a relationship?

10. Personal Oracle 7 vs Paradox 7 vs Local Interbase