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.