ORA-01410: invalid ROWID

[Goffman]

Hello!

If I set the UniqueFiels with some fieldname DOA will use this fieldname in DML instead of Rowid, doesn't it?

But if I set RefreshOptions=(roBeforeUpdate) it will use Rowid in select predicate before updating a row.

My join query doesn't have any correct rowid so it raises error.

Is it bug or feature?
Please, tell me what should I do?

 

[Marco Kalter]

The UniqueFields property will be used to determine the rowid when a new record is inserted. The rowid will be used for other functions though (such as refreshing).

If your query cannot produce a rowid, you will need to write an OnApplyRecord event handler to process the inserts, updates, deletes, locks, and refreshes.

 

[Goffman]

Hello Marco.
I don't think it is logical behaviour
But anyway thank you for your answer

 

[Pavel]

Originally posted by Marco Kalter:
The UniqueFields property will be used to determine the rowid when a new record is inserted. The rowid will be used for other functions though (such as refreshing).

If your query cannot produce a rowid, you will need to write an OnApplyRecord event handler to process the inserts, updates, deletes, locks, and refreshes.

Hello!

It is not work on Oracle 10