The question is which row you consider to be the first. Maybe you can use the where limit =1 in combination with an order by
Tony -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Bruce A. Chitiea Sent: maandag 1 juli 2013 19:44 To: RBASE-L Mailing List Subject: [RBASE-L] - SELECT <First Row> All: RBGeX95(64) Current I want to hunt for certain strings within field 'humpty'. This works: DECLARE c1 SCROLL CURSOR FOR + SELECT humpty FROM wall OPEN c1 FETCH FIRST FROM c1 INTO vhumpty IND vind1 <Process> DROP CURSOR c1 Is there any direct means of SELECTing the FIRST row from table without having to resort to a cursor? Thanks Bruce Chitiea SafeSectors, Inc. eCondoMetrics 909.238.9012 cell --- RBASE-L ================================================ TO POST A MESSAGE TO ALL MEMBERS: Send a plain text email to [email protected] (Don't use any of these words as your Subject: INTRO, SUBSCRIBE, UNSUBSCRIBE, SEARCH, REMOVE, SUSPEND, RESUME, DIGEST, RESEND, HELP) ================================================ TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO ================================================ TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE ================================================ TO SEARCH ARCHIVES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: SEARCH-n (where n is the number of days). In the message body, place any text to search for. ================================================
