show all records in a Grid !

The place for peer-to-peer support for VPM Enterprise 9.1, our latest framework.

show all records in a Grid !

Postby expresys » Sat Jan 06, 2018 5:53 pm

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
expresys
 
Posts: 155
Joined: Tue Jul 06, 2010 1:45 am

Re: show all records in a Grid !

Postby stecenko » Mon Jan 08, 2018 12:59 pm

After you select the records for the grid do a go top.

Or check you order clause.
Richard Stecenko
Interactive Computer Services Inc.
Victoria, British Columbia
204.453.2052
stecenko
 
Posts: 822
Joined: Mon Jun 21, 2010 8:06 pm
Location: Saanich, British Columbia

Re: show all records in a Grid !

Postby cti2 » Mon Jan 08, 2018 2:02 pm

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
cti2
 
Posts: 181
Joined: Wed Oct 13, 2010 6:38 am

Re: show all records in a Grid !

Postby expresys » Tue Jan 09, 2018 6:05 pm

Thanks You Richard & Pete both solutions works!
expresys
 
Posts: 155
Joined: Tue Jul 06, 2010 1:45 am


Return to VPM Enterprise 9.1

Who is online

Users browsing this forum: No registered users and 5 guests

cron