ExternalCursor problem

[al0]

Hi,

If I create dataxset based on external cursor (TQuery) and I try to edit data I receive "ORA-00903:Invalid table name)". TQuery is not obtained as cursor parameterfrom procedure, but just contain plain select from single table.

 

[Marco Kalter]

What happens if you set the UpdatingTable property of the TOracleDataSet?

 

[al0]

Originally posted by Marco Kalter:
What happens if you set the UpdatingTable property of the TOracleDataSet?

In thi9s case it works fine. Sorry, I forgot to mention it in my first letter. But it is not mentioned in documentation that it is necessary.

 

[al0]

Small addition to previous post concerning documentation.

The documentation state:

Note

If the dataset is connected with an ExternalCursor, it cannot implicitly be refreshed. Use the BeforeRefresh event handler of the dataset to reopen the cursor, or prevent refresh operations.

This is not true (at least,not completely true). In case of External query build around SQL (not arount the cursor, returned from procedure) implicit refresh works fine.

 

[Marco Kalter]

You're right. We'll fix the documentation.

 

[al0]

Originally posted by Marco Kalter:
You're right. We'll fix the documentation.

For 4.0.4 nor doc nor help are fixed.