Home   |   Register   |   Rules   |   Calendar   |   Get Daily   |     |  
 


If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

 
Go Back  dBforums > Database Server Software > Pervasive.SQL > Returning FIRST row

Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1 (permalink)  
Old 11-02-04, 15:37
NetGuy NetGuy is offline
Registered User
  
Join Date: May 2003
Posts: 6
Thumbs down 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!
Reply With Quote
  #2 (permalink)  
Old 11-02-04, 15:44
mirtheil mirtheil is offline
Registered User
  
Join Date: Dec 2001
Posts: 1,026
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.
Reply With Quote
  #3 (permalink)  
Old 11-02-04, 15:46
NetGuy NetGuy is offline
Registered User
  
Join Date: May 2003
Posts: 6
I am using Pervasive.SQL 2000i

Is there something like that in this version?
Reply With Quote
  #4 (permalink)  
Old 11-02-04, 18:43
mirtheil mirtheil is offline
Registered User
  
Join Date: Dec 2001
Posts: 1,026
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.
Reply With Quote
Reply

« Previous Thread | Next Thread »
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes
Linear Mode Linear Mode

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts
BB code is On
Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


 
 
 
Home  |   Register  |   Get New  |   FAQ's  |   Sitemap

Powered by vBulletin
Copyright ©2000 - 2012, Jelsoft Enterprises Ltd.