Thanks to all who provided the answer. I got exactly what I wanted. James Belisle
-----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Victor Timmons Sent: Tuesday, December 07, 2010 5:12 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: browse table at last entry Thats cool. I think I would change it just a little SELECT ((COUNT(*))-30) INTO vROWS INDIC ivRows FROM SomeTableName;BROWSE ALL FROM SomeTableName WHERE COUNT > .vRows ORDER BY Something DESC Victor Timmons Tiz's Door Sales, Inc Visit us at www.tizdoors.com P Please consider the environment before printing this e-mail -----Original Message----- From: [email protected] [mailto:[email protected]] On Behalf Of Mike Byerley Sent: Tuesday, December 07, 2010 2:58 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: browse table at last entry select count (*) into vcount ind vin0 from SomeTableName set var vCount = (.vCount - 30) browse * from SomeTableName where count > .vCount ----- Original Message ----- From: "Jim Belisle" <[email protected]> To: "RBASE-L Mailing List" <[email protected]> Sent: Tuesday, December 07, 2010 5:24 PM Subject: [RBASE-L] - RE: browse table at last entry I do not have this field in this table. I see the use of it now. I know I can just use the BROWSE * then hit the last row button. I would like to limit the rows to say 30 but I want the last 30. James Belisle ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Dennis McGrath Sent: Tuesday, December 07, 2010 4:19 PM To: RBASE-L Mailing List Subject: [RBASE-L] - RE: browse table at last entry If your table has an integer Primary Key, sort by that descending. BROWSE Product order by ProductID DESC Dennis McGrath ________________________________ From: [email protected] [mailto:[email protected]] On Behalf Of Jim Belisle Sent: Tuesday, December 07, 2010 3:47 PM To: RBASE-L Mailing List Subject: [RBASE-L] - browse table at last entry I know the code BROWSE Product WHERE COUNT = LAST brings up the last row in a table. I want to go to the last row but see the other rows in the table. What code do I use? James Belisle --- RBASE-L =======================3D=======================3 D= 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) =======================3D=======================3 D= TO SEE MESSAGE POSTING GUIDELINES: Send a plain text email to [email protected] In the message SUBJECT, put just one word: INTRO =======================3D=======================3 D= TO UNSUBSCRIBE: Send a plain text email to [email protected] In the message SUBJECT, put just one word: UNSUBSCRIBE =======================3D=======================3 D= 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. =======================3D=======================3 D=
