Show the last 5 record

[Silvio.Falconi]

How I can show on a xbrowse only the last 5 record from a archive ?

[joseluisysturiz]

Buen dia, probastes hacer un array ordenado por nRow descendente y luego leer los 5 primeros y agregarlos a oBrw:aArraydata.? Solo es una idea al vuelo, saludos...

[ukoenig]

Silvio,

works with any index :

using a FILTER

nTop := ("CUST")->( RECCOUNT() ) - 4
("CUST")->( DBSETFILTER( {|| ("CUST")->( RECNO() ) >= nTop } ) )
("CUST")->( DBGOTOP() )

or using ORDSCOPE with the same result :

INDEX ON ("CUST")->( RECNO() ) TO "CUST1" // index on record-numbers
nTop := ("CUST")->( RECCOUNT() ) - 4
nBottom := ("CUST")->( RECCOUNT() )

("CUST")->( ORDSCOPE(0, NIL ) ) // reset
("CUST")->(ORDSCOPE(1, NIL ) ) // reset

("CUST")->(ORDSCOPE(0, nTop )) // set top scope
("CUST")->(ORDSCOPE(1, nBottom )) // set bottom scope
("CUST")->( DBGOTOP() )



regards
Uwe

[Silvio.Falconi]

YES RUN OK

FIRST SAMPLE