Selectall statement that stays at or returns to the current record

James Rea jim at provue.com
Tue Mar 4 15:32:06 PST 2008


> I know it would be possible to make a custom statement that returns to  
> the current record after a selectall statement rather than stopping on  
> the first record. This would require specifying a field to use for the  
> find formula after the selectall.
> 
> Jim, I am wondering whether a variation of the selectall statement  
> could be made that would return to the current record automatically  
> based on the record id or faster yet, never leave the current record?

In single user databases there is no record ID. Here's one way to do
this that should work unless your database contains totally duplicate
records.

local xr
xr=exportline()
selectall
find xr=exportline()

You'd probably want to throw noshow/showpage/endnoshow statements in
there.

Jim Rea
President, ProVUE Development

---------------------------------------------------------------------
---   Celebrating 29 years of software excellence (1978-2007)     ---
---------------------------------------------------------------------
ProVUE Development          (714) 841-7779
18685-A Main Street PMB356  http://www.provue.com/
Huntington Beach, CA 92648  Panorama: Turn information into knowledge
---------------------------------------------------------------------


More information about the Qna mailing list