problem with oracle dbexpoda using the UNION SQL command.

[clebernardelli]

I have problem with access to Oracle dbexpoda using the UNION command in SQL.

My table:

CREATE TABLE TEST
(A NUMBER (4),
B NUMBER (8),
C NUMBER (15));

When i SELECT * FROM TEST the list of fields that returns is:
A TSmallIntField
B TIntegerField
C TFLOATFIELD

But when i do SELECT * FROM TEST UNION SELECT * FROM TEST the list of fields that returns is:
A TFLOATFIELD
B TFLOATFIELD
C TFLOATFIELD

The driver version is: 2.10 the delphi version is 7 Enterprise and Oracle version is 9.2 (but tested on version 10g and also happens).

The parameters using in driver is:
EnableBCD=False
IntegerPrecision=9
SmallintPrecision=4
FloatPrecision=38

Someone help me please?

[Plash]

Oracle does not return the precision of fields when you are using UNION. So you should work with different field lists for these two queries.