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