Dear

I have a customize table with four fields.

1. Warehouse 2. Item code 3. Value 4. abc

We want to update abc field with descending order of Value field

I made a index on value and item

What command for that. Syntax is as below

select tdkci088.*
from tdkci088 for update
order by tdkci088._index3
selectdo
update.abc.record()
endselect

you can use the keyword desc for sorting the table in descending order.

Dear KS

thanks