Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations derfloh on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Limit Number of Records returned

Status
Not open for further replies.
Mighty

Mighty

Programmer
Joined
Feb 22, 2001
Messages
1,682
Location
US
in MS Access, you can add the "TOP" keyword to select queries to get the last 5 records for example. Is there a way to do this in Pervasive??

Mighty
 
Sort by date Sort by votes
Yes, but it depends on the version you're using - it can be done in version 8
 
Upvote 0 Downvote
Thanks Tom.
Unfortunately, we don't have version 8 yet.

Mighty
 
Upvote 0 Downvote
See thread318-742975.

zemp
 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

ianbtheog
  • Locked
  • Question Question
Connection Manager is not running at the specified port number - Pervasive 13.31.014 - Intermittent
Replies
2
Views
831
ianbtheog
ianbtheog
David Ford
  • Locked
  • Question Question
[pervasive][odbc client interface] Numeric value out of range. (#0) - MS Access and Sage 50
Replies
2
Views
508
David Ford
David Ford
Mimi2012
  • Locked
  • Question Question
Stored procedure in Pervasive.SQL V8, using one of table column of 50 TIMES PIC 9(4).
Replies
0
Views
229
Mimi2012
Mimi2012
leftee
  • Locked
  • Question Question
Check for Existing Records Before doing Insert
Replies
3
Views
378
mirtheil
mirtheil
mrdjsm1th
  • Locked
  • Question Question
Limitations of Subquery or View
Replies
6
Views
291
mrdjsm1th
mrdjsm1th

Part and Inventory Search

Sponsor

Back
Top