Page 1 of 1

show all records in a Grid !

PostPosted: 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 !

PostPosted: 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 !

PostPosted: 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 !

PostPosted: Tue Jan 09, 2018 6:05 pm
by expresys
Thanks You Richard & Pete both solutions works!