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
