TFloatField, TIntegerField mapping

[ThomyKay]

I have 2 SQL statements in my app.

One (a select to a nested table) has (PL/SQL integer and float fields). This one is mapped the right way on the DOA side.

The other does a select in an object table (having integer attributes) and its aggregate object (having float attributes). Here I don't get the float attributes as FloatFields...?

I know about InterPrecision, FloatPrecision properties in OracleSession. But what's the difference for Oracle/OCI/DOA? How is the mapping done internally?

 

[ThomyKay]

I think the Data Dictionary must be corrupted. I've tried it with a new installed instance and it works fine. Which Data Dictionary Views are used to determine the field types?

 

[Marco Kalter]

No dictionary view is used. When the query is opened the field types are reported by SQL*Net / Net8.

------------------
Marco Kalter
Allround Automations