Results 1 to 3 of 3
  1. #1
    Join Date
    Sep 2003

    Unanswered: Using the TOP syntax

    Was just wondering if anyone knew how to execute a pervasive statement with a syntax similar to a mysql query of

    SELECT * FROM table LIMIT x,y

    i want to query starting from row x with a limit of y results. I looked into TOP but it seems it will only limit the number of results and not the starting row.

  2. #2
    Join Date
    Dec 2001
    Provided Answers: 6

    Re: Using the TOP syntax

    There is no LIMIT syntax in Pervasive.SQL. You can, if you're using V8, us the TOP statement and a WHERE clause to set the start row. Something similar to:
    SELECT top X FROM table WHERE field=Y
    Also, if you really need this syntax contact Pervasive to tell them you need it.
    Hope this helps.
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    Sep 2003
    ok no worries. thanks for that.

Posting Permissions

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