Page 1 of 1
show all records in a Grid !
Posted:
Sat Jan 06, 2018 5:53 pm
by expresys
Hi, does anyone know why always when the data is display in a grid only shows the last record of the table at the top of it and I have to see the other records by moving up with my sidebar ?
Thanks
Re: show all records in a Grid !
Posted:
Mon Jan 08, 2018 12:59 pm
by stecenko
After you select the records for the grid do a go top.
Or check you order clause.
Re: show all records in a Grid !
Posted:
Mon Jan 08, 2018 2:02 pm
by cti2
Using just a simple LOCATE with no argument, instead of GO TOP, can sometime be much quicker, depending on record count, SET FILTERS and engaged INDEX.
I often also use This.Grid1.DOSCROLL(2) in the container that holds the grid, typically in REFRESH method.
Ex:
SELE customers
LOCATE
This.Grid1.DOSCROLL(2)
Pete Ryder
Re: show all records in a Grid !
Posted:
Tue Jan 09, 2018 6:05 pm
by expresys
Thanks You Richard & Pete both solutions works!