Refresh a single Record

[cadotp]

Context: Windows 95b - Delphi4 UP3 - DOA 3.3.3 - Oracle 8.1.6

I use a dataset where SQL property is a SELECT on a view (VIEW1). My view VIEW1 is a SELECT on a table (TABLE1).
I have to update one record from table TABLE1.
So, I want to update my view VIEW1 too. But I want to refresh only the record which was updated. So I use 'Locate' property to find correct record and I use 'RefreshRecord' method. But this returns an exception : 'ORA-00942 : table or view does not exist'. I can't understand ! My dataset SQL property is well filled. Is it due to my view (which is not a table) ? Will it be better to use updatable view ? Is there a bug in RefreshRecord method ?

Any other ideas ?
Thanks a lot.

 

[Marco Kalter]

Set TOracleDataSet.Debug to True and see what select statement is executed. This should provide a clue.

------------------
Marco Kalter
Allround Automations

 

[cadotp]

You're right (as usual)!!
This property (Debug) is absolutely marvellous !!

Explanation : 'UpdatingTable' property of my dataset was wrong (this property was filled a long time ago)!
This problem enables me to understand 'updatable view' principle and to use correctly 'UpdatingTable' property.

Thank's Marco to remind me of 'Debug' property.