Pageable Query

[william_reinhold]

wondered if there was anyway to have a query that returned a pageable
recordset. A table we use has over a million records and when
searching by name infopath can return a 1000+ records for a name like
smith, just wondered if there was a way to have the query return like
the first 50 then have a navbar to page through the remainder or next
previous navigation.

 

[Alex [MSFT]]

I recommend controlling the number of returned records via a dynamic query
(i.e. using SQL sub-statements like "LIMIT 50"). You will need to write some
custom code to generate this dynamic query, but the benefits will be huge -
you will have 50 records going through the wire at once, instead of 1000+.

Good luck,
Alex @ Microsoft

 

[william_reinhold]

ok, thanks.
Sounds like I'd be better to figure how to incorporate a dynamic grid
that the user could set rows to return and then navigate accordingly.
I'm assuming from what you wrote that I would also have to write a
piece to handle paging forward and backward through the table at user
demand. ie, next 50, previous 50
I'm open ears for any suggestions to speed this up. we have an
enormous number of items to convert and would like to create a stock
routine that can do this by just modifying the connections and fields.