select last inserted record
Posted: 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
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