select last inserted record

Discussion of open issues, suggestions and bugs regarding SDAC (SQL Server Data Access Components) for Delphi, C++Builder, Lazarus (and FPC)
Post Reply
RoniLev
Posts: 7
Joined: Sun 02 Mar 2014 21:04

select last inserted record

Post by RoniLev » Thu 23 Apr 2020 13:57

Hi
i have a large clients table.
I use TMSQuery to select top 200 to show only part of it in a grid. (limited by the where clsaus)
problem:
when the user add new client it is not visible in the grid (it not in the record set of the TMSQuery)
is there a way to show it ?
or perform a new select that will show X records before and after it?
Thanks
Roni

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

Re: select last inserted record

Post by Stellar » Thu 23 Apr 2020 14:33

The TMSChangeNotification component in SDAC Professional Edition is responsible for receiving notifications from the server and keeping the dataset up-to-date.

SDAC Professional Edition contains a component called TMSChangeNotification, which receives notifications from the server and keeps the dataset up-to-date. SDAC demo project contains an example in the ChangeNotification tab, which shows the operation of the TMSChangeNotification component.

More about TMSChangeNotification:
https://www.devart.com/sdac/docs/devart ... cation.htm

Post Reply