Shane, If you _really_ want only the last record (and, maybe, the immediately preceding ones) can you not re-display the data sorted DESC instead of ASC (or whichever way around you're using)?
If you didn't already know, EDIT USING allows you to sort the secondary table(s) using the ARRANGE parameter. Regards, Alastair. ----- Original Message ----- From: "Shane Handley" <[EMAIL PROTECTED]> To: "RBASE-L Mailing List" <[EMAIL PROTECTED]> Sent: Thursday, February 12, 2004 6:41 AM Subject: [RBASE-L] - Re: Moving to the last row on a tiered form -Razzak's Reply > Thanks Rick and Razzak, > > This method will achieve what I want, but with very large amount of data and a > lot of rows in a big form it can be very sluggish (moves at about 1 row per > second) and even managed to crash Rbase. > > It would be ideal to make use of the Unique value in each row to jump from place > to place, although I think this may be a bit ambitious. > > Thanks, > > Shane Handley > > > Shane, > > > > Using the 6.5++ for Windows, if you know the total number of > > records being displayed in a form with a region, you can define > > an EEP using the NEXTROW command to get to the last row or > > using the PREVROW command to get to the first row. You'll have > > to keep the counter and then add or subtract the the counter > > accordingly. I'm sure there are various other ways to achieve > > the same goal. > > > > Using the next generation R:BASE 7.0 for Windows, things are > > way cooool to navigate records while in a form using Scrolling > > Region. Among 78 Form Controls and more ... you have the option > > to use DB Navigator control with the following options: > > > > . First > > . Previous > > . Next > > . Last > > . Insert > > . Delete > > . Edit > > . Save > > . Cancel > > . Refresh > > > > Using the PROPERTY command in an EEP or Custom Embedded EEP, > > you can use the following commands to jump to the FIRST or > > the LAST record. > > > > Here's how: > > > > To jump to the first record: > > > > PROPERTY TABLE tablename 'FIRST' > > RETURN > > > > To jump to the last record: > > > > PROPERTY TABLE tablename 'LAST' > > RETURN > > > > That's all there is to it! > > > > Very Best R:egards, > > > > Razzak. > > > > At 12:11 PM 2/12/2004 +1000, Shane Handley wrote: > > > > >Hi all, > > > > > >I am running RB6.5++ and was wondering if there is a way to move to the > last > > >row within a tiered form by clicking a button. > > > > > >If it helps, each row already contains a unique value, so if it is > > >possible to move > > >to a row based on this columns value, I would greatly appreciate some > example > > >code. > > > > > >Thanks in advance. > > > > > >Shane Handley >
