RefreshRecord on nomore-existent record

[Alberto Pilat]

Hi,
I'm trying to use RefreshRecord on a quite complex query that has several joins and a complex where section; so I've activate roAllField option.
It happens that when RefreshRecord is called, the current record doesn't match the 'where' condition anymore, infact OracleMonitor return 0 rows selected, correctly.
But nothing happens on the dataset that invoked the method, so that I can't understand if the record is still valid or not.
Is it this the right behavior?
I need to exclud a complete dataset refresh because of the heavy of the query.

Thanks

 

[Marco Kalter]

This is indeed the expected behavior. The record refresh function will not remove the record from the dataset.

Why does the record no longer match the where clause? If this is caused by an action in the application, then the application can perhaps actively remove the record.

 

[Alberto Pilat]

Yes, you're right, in fact the needded was born because of web-application when records can be manipulated by others users.
But it's all right, I've found a workaround.
Thanks