>Tore --
>
>Unfortunately, neither of your suggestions are usable. The first fails because the table is ordered, so the record numbers appear to be random. The second fails for the same reason as well as because the table is filtered.

So then there is a key... and maybe a filter. How about this (had to use {{ and }} for text delimiters):

cOrder=key()
private uCurrent
uCurrent=eval(cOrder)
cFilter=filter()
if !empty(cFilter)
   cFilter=" and " +cFilter
endif
TEXT TO c NOSHOW TEXTMERGE
select * from TheTable where {{cOrder}}<=uCurrent {{cFilter}};
	into cursor tmp
ENDTEXT
=execscript(c)

With the filter there's an odd chance that the expression may include something that wouldn't work in a sql statement - in that case, this would have to be a "copy to ... for {{cOrder}}<=uCurrent {{cFilter}}"
There's