General information
Category:
Internet applications
I am looking for a good methodology for paging result sets of data, using a VFP7 DBC as a data source. My current method breaks down as the original table gets large. This is for serving the table rows on the web.
Currently I am doing this:
Get RecCount() of table (now 100,000 rows and growing)
Divide Int( RecCount() / iRows + 1 )to get total number of pages
If I want the first page
Multiply total number of pages * page wanted to get bottom page row number
Add number of rows wanted + bottom range row to get top range row number
Select * from table where RecNo() between bottom and top row number wanted
What are you guys doing?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only