Results 1 to 2 of 2
  1. #1
    Join Date
    Oct 2005

    Unanswered: 'next' and 'previous' page problem

    Hi there! I'm needing to only call a certain number of records based on the page the user is on . When the user clicks 'next' the next page displays the next set of results (obviously). At the moment I'm loading the whole result set every page and just limiting what the user sees. This way is very slow because everytime i'm calling the entire result set. Any way around this with modifying my SQL statement to just call records (i.e.) between 20 and 40 ? (and then the next page calling 40 and 60, etc.)

  2. #2
    Join Date
    Dec 2001
    Provided Answers: 4
    You might be able to limit the resultset with a "WHERE" clause. It'll probably depend on the structure of your data. Unfortunately, there's no "LIMIT" clause in PSQL.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    I do not answer questions by email. Please post on the forum.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts