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
