I have OracleDataSet(DOA 3.4.3) that retrive data with simple SQL
select
id,
name
from Unit
ID is primary key on Unit.
For some reason I don't use rowid and I want that Check, Lock, and Refresh use id instead of rowid. OracleDataSet have property UniqueFields that can serve my purpose. I set UpdateFields to 'id'. OracleDataSet.CanModify remain false during runtime. If I have OnApplyRecord handler and not handle 'C', 'L', 'R' I get error:
"A lock, refresh or check cannot be performed without a rowid. Provide a rowid in the query or handle this action in the OnApplyRecord event."
So, my question is:
What I can do in order to Check, Lock and Refresh work with 'id' without handle this action in OnApplyRecord?
Thanks for any advice.
Alex
select
id,
name
from Unit
ID is primary key on Unit.
For some reason I don't use rowid and I want that Check, Lock, and Refresh use id instead of rowid. OracleDataSet have property UniqueFields that can serve my purpose. I set UpdateFields to 'id'. OracleDataSet.CanModify remain false during runtime. If I have OnApplyRecord handler and not handle 'C', 'L', 'R' I get error:
"A lock, refresh or check cannot be performed without a rowid. Provide a rowid in the query or handle this action in the OnApplyRecord event."
So, my question is:
What I can do in order to Check, Lock and Refresh work with 'id' without handle this action in OnApplyRecord?
Thanks for any advice.
Alex
