use myTable exclusive index on ClientNo tag ClientNo select sys(2015) as SortOrder,* from myTable ; order by 1 descending ; into cursor crsTemp nofilter select myTable zap select crsTemp scan if !seek(ClientNo,'myTable','ClientNo') scatter memvar memo insert into myTable from memvar endif endscanthank you.
>use myTable exclusive >index on ClientNo tag ClientNo >select sys(2015) as SortOrder,* from myTable ; > order by 1 descending ; > into cursor crsTemp nofilter >select myTable >zap >select crsTemp >scan > if !seek(ClientNo,'myTable','ClientNo') > scatter memvar memo > insert into myTable from memvar > endif >endscan >Cetin