Reposition browse to last screen of records

[ChrisJRutter]

I know I've done this before but the answer escapes me now

Can anyone tell me how to scroll to the last screen of records in a browse?

I have a browse displaying dated transactions and on startup I want to present the user with the most recent records (in ascending date order).

Thanks in advance.

 

[mpowell_esq]

Use a buffer

Use a buffer to open your query to first. Once you have opened your query store the record num of the last row in a var iEndRec, start to display the ouput to screen / live / browser where the record num is iEndRec - 10 (or the number of rows your browser is configured to display)
Have fun

 

[Lee Curzon]

If you just want to move to the last record (as opposed to first record on last page)...

APPLY "END" TO {&BROWSE-NAME}.

HTH

 

[Lee Curzon]

Alternatively, you could display the records in descending date order, and position to first.

 

[ChrisJRutter]

Thanks for the suggestions.

I'd just stumbled on the APPLY 'END' as I got your message Lee!

Does exactly what I need.

Cheers