Dataset refresh when recieving notification of deleted record

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
bryn.ball
Posts: 9
Joined: Mon 08 Dec 2014 03:32

Dataset refresh when recieving notification of deleted record

Post by bryn.ball » Mon 01 Apr 2019 20:48

Hi

I have noticed that if one instance of my application receives notification of a record deletion in the main dataset and it is currently displaying the deleted record, when the notification is applied i.e. the dataset is refreshed, instead of moving back to the prior viable record it displays the first record in the dataset. Is this intentional?

The query is ordered by an ascending integer id. I am sure that before I upgraded to the latest version it used to move back to the prior record in the sequence.

Regards
Bryn

Stellar
Devart Team
Posts: 248
Joined: Tue 03 Oct 2017 11:00

Re: Dataset refresh when recieving notification of deleted record

Post by Stellar » Wed 03 Apr 2019 15:06

Thank you for the information. Currently, when you update a record by calling the Refresh method, an automatical switch to the first record in the dataset is performed if the selected dataset record was deleted on the server.
We will consider a possibility of implementing the specified functionality in one of the next SDAC versions.

Post Reply