How to retrieve field information

[JIDORI]

Hi,

I want to retrieve the data type, size and precision information of the fields like this:

Field1 VARCHAR2 40
Field2 NUMBER 10 0

On BDE, DbiGetFieldTypeDesc API seems to provide this type of information.
Could anyone help me?

Thanks

 

[Marco Kalter]

The TOracleQuery allows you to obtain this information through the FieldType, FieldSize, FieldPrecision and FieldScale functions.

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

 

[JIDORI]

Thanks a lot.