At 01:44 PM 7/1/2013, Bruce A. Chitiea wrote:
Is there any direct means of SELECTing the FIRST row from table without having to resort to a cursor?
Bruce, It all depends on your expected result of FIRST row, as Tony IJntema suggested in his earlier reply. If you are importing a file, such as XLS, in a "new" table, to find the first imported row, use the WHERE COUNT = nn, as follows: BROWSE * FROM newtablename WHERE COUNT = 1 The following WHERE clause specifies the seventh row. BROWSE * FROM newtablename WHERE COUNT = 7 Hope that helps! Very Best R:egards, Razzak. www.rbase.com www.facebook.com/rbase -- 30+ years of continuous innovation! 15 Years of R:BASE Technologies, Inc. making R:BASE what it is today! --
