Solved

Delphi multi-RDBMS support with Oracle/Interbase

Posted on 2000-03-14
4
180 Views
Last Modified: 2012-05-04
I have a problem with adding support for Oracle as a back-end to an application that already supports InterBase/MSSQL and SyBase.

I have some TTables/TQuery's with predefined fields (means they are created in the IDE). There FieldType and Size are determined by the IDE (and BDE).

The problem is that Oracle does not know the INTEGER type but uses NUMERIC(0,*) for this. Delphi (and BDE) interpret this as a TFloatField. Because the application is developed with Interbase as a base database, the predefined field are of type integer. And opening a Query that has a TIntegerField when a TFloatField is expected generates a exception...

Does anybody have experience in solving this issue.

(An obvious solution which I am NOT looking for is fixing this at Form or DataModule creation time by storing/freeing/recreating the fielddefs and restoring every interesting property on recreation).

Regards,
Jacco
0
Comment
Question by:Jacco
[X]
Welcome to Experts Exchange

Add your voice to the tech community where 5M+ people just like you are talking about what matters.

  • Help others & share knowledge
  • Earn cash & points
  • Learn & ask questions
  • 3
4 Comments
 
LVL 27

Expert Comment

by:kretzschmar
ID: 2616930
? Oracle did not have an integer-type ?
see http://agec16.agecon.uiuc.edu:8000/WG73-doc/server/sql73/ch205.html
0
 
LVL 27

Accepted Solution

by:
kretzschmar earned 100 total points
ID: 2618774
hi jacco,

have done some tests and see now your problem.

a workaround:

if u use the bde oracle native driver set the
- entry enable integer to true
- alter the field with the type NUMBER(*,0) to NUMBER (10,0)

this should do the trick

meikl
0
 
LVL 10

Author Comment

by:Jacco
ID: 2618895
Thanks Meikl,

It is always very nice to post a question when you leave work and have it solved overnight :-)

Regards Jacco
0
 
LVL 27

Expert Comment

by:kretzschmar
ID: 2620479
yup, jacco,

thats a feature of ex-ex :-))
well, glad to helped you,
good luck again

meikl
0

Featured Post

Free Tool: Postgres Monitoring System

A PHP and Perl based system to collect and display usage statistics from PostgreSQL databases.

One of a set of tools we are providing to everyone as a way of saying thank you for being a part of the community.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Suggested Solutions

Objective: - This article will help user in how to convert their numeric value become words. How to use 1. You can copy this code in your Unit as function 2. than you can perform your function by type this code The Code   (CODE) The Im…
In my programming career I have only very rarely run into situations where operator overloading would be of any use in my work.  Normally those situations involved math with either overly large numbers (hundreds of thousands of digits or accuracy re…
A short tutorial showing how to set up an email signature in Outlook on the Web (previously known as OWA). For free email signatures designs, visit https://www.mail-signatures.com/articles/signature-templates/?sts=6651 If you want to manage em…

763 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question