Problems with Cashed Updates

[mczk]

If I set OracleDataSet.CachedUpdates := true, I receive error "Cached updates requires a rowid!"

To avoid this error I added to the oracle table the field "id" with type "rowid".

The error disappeared, but I received the error: "ORA-03120: two-task conversion routine: integer overflow"

What am I doing wrong?

------------------
McZK

 

[P. Maquet]

You can suppress your column ID of type rowid, it is not the solution.

In your query, simply add "rowid" amongst the columns list, like here :

select t.*, t.rowid from MY_TABLE t ...

ROWID is a system "virtual" field which represents the physical address of any Oracle record.

Phil.

 

[mczk]

Thank you.
Now it works!

------------------
McZK