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
