TOracleQuery.First

[ASDD]

We have installed DOA 4.0.0 components (Trial version). In order to use scrollable query possibility we also have installed Oracle 9.2.0.4 EE (and clients respectively) in according with your DOA/news webpage information.

In Delphi project we set the property
TOracleQuery.Scrollable in TRUE;
But after executing the query (Execute), when we try to call First method, the exception raised:
"TOracleQuery.First only possible on Oracle Net 9.0 or later."

What can we do in this situation?

Thank you.

 

[Marco Kalter]

Is your Pimary Oracle Home also 9.2.0.4? It would seem that it is 8.1.7 or earlier.

 

[ASDD]

Thank you for the answer.

We are sure that Primary Oracle Home is 9.2.0.4

in addition to yesterday information:
during the latest experiments we have recognized that
if TOracleQuery is based on one table only (select * from table1) - all works correctly, but if it's based on more than one table (select table1.name, table2.name from table1, table2 where table1.id = table2.id) the exception previously specified raised.

Perhaps it will help to understanding the problem.
Thank you.

 

[Marco Kalter]

That would be strange. The actual SQL should not matter at all. Can you send me something to reproduce this?

 

[ASDD]

In continuation:

TOracleQuery.SqlText :=

SELECT
b.comments,
a.data_type,
a.data_default,
a.nullable,
a.column_name
FROM
all_tab_columns a,
all_col_comments b
WHERE
UPPER(a.table_name) = UPPERTableName)AND
(b.table_name = a.table_name) AND
(b.column_name = a.column_name)
ORDER BY
b.comments

We use this syntax for selecting descriptions (such as comments, data_type etc.) for all fields of any table sending into query through :TableName variable.

property Scrollable is True (set in design time)

DeclareVariable('TableName', otString);
SetVariable('TableName', );
Execute;

after this exception raised.

Thanks for your patience.