Some newby questions...

[jhui]

Hi,

I am new to DOA.
I am about to migrate a Delphi 5 MIDAS 3 / BDE application to DOA.

I have some questions:

1] How can I obtain columninfo (basetable/basecolumn) for each query that is executed ?

2] How can I obtain metadatainfo about tables, indexes and columns. For columns I have need for info to reconstruct the SQL data type.

TIA

Jan Huizinga

 

[Marco Kalter]

The base table and base column information is not available. For the meta data information you have to query the Oracle Dictionary (all_tables, all_tab_columns, all_indexes, all_ind_columns).

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