Results 1 to 4 of 4
  1. #1
    Join Date
    May 2003
    Posts
    6

    Thumbs down Unanswered: Returning FIRST row

    in Pervasive SQL, does anyone know how to return the first row in the query.

    similar to the scalar function First() in MS Access.

    Thanks!

  2. #2
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    What version of Pervasive? If it's V8, you can use the TOP keyword. Just out of curiosity, why are you wanting only the first record in a result set?
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    I do not answer questions by email. Please post on the forum.

  3. #3
    Join Date
    May 2003
    Posts
    6
    I am using Pervasive.SQL 2000i

    Is there something like that in this version?

  4. #4
    Join Date
    Dec 2001
    Posts
    1,109
    Provided Answers: 4
    I'm not aware of anything for 2000i.

    Just out of curiosity, why are you wanting only the first record in a result set?
    Mirtheil Software
    Certified Pervasive Developer
    Certified Pervasive Technician
    Custom Btrieve/VB development
    http://www.mirtheil.com
    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
  •