Table generates TIntegerfield / View with Union generates TFloatfield

rdeutsch · Post by **rdeutsch** » Mon 03 Jan 2005 10:56

Hi

When in a table a field is defined as integer (number(1,0)) --> the persistent queryfield has the type: TIntegerField.
But if I create a view including a union, delphi or ODAC recognize the same field as TFloatField. Therefore I get error messages in my forms, because the same form use both, one time the TABLE and an other time the VIEW. But i need the persistent fields.

Does anyone have a solution for this problem?

Regards
Robert

ODAC Version 5.10.0.5 for Delphi 7

Paul · Post by **Paul** » Tue 04 Jan 2005 07:24

This is a known Oracle bug #2820295. See the following information.

Implicit describe of a SELECT looses NUMBER precision for VIEW
containing UNION
This note gives a brief overview of bug 2820295.
Affects:

Product (Component) Oracle Server (Rdbms)
Range of versions believed to be affected Versions < 10G
Versions confirmed as being affected

* 9.2.0.4

Platforms affected Generic (all / most platforms affected)

Fixed:

This issue is fixed in

* 9.2.0.5 (Server Patch Set)
* 10g Production Base Release

Symptoms:

* Wrong Results

Related To:

* OCI

Description

An implicit describe on a VIEW containing a UNION of two columns of
NUMBER data type looses precision on the resultant NUMBER view column.

rdeutsch · Post by **rdeutsch** » Tue 04 Jan 2005 10:02

Hi Paul

Thanks for fast reply. We are changing the db on version 9.2.0.6.

Best regards
Robert