delete your tags. Sort on "main" key. INDEX (not reindex) the table. You may have some farkled data. Have you been able to browse the key fields?


>>Order is defined desc or open desc ?
>>You have REINDEX ?
>>
>>You can try this:
>>

>>orderNo = TAGNO('order')
>>orderExp = KEY(m.orderNo)
>>orderSingle = PRIMARY(m.orderNo) OR CANDIDATE(m.orderNo)
>>select 0
>>use mytable again
>>scan
>>  if !SEEK(EVAL(m.orderExp), 'mytable', 'order') OR recno()#recno('mytable') AND m.orderSingle
>>      ? EVAL(m.orderExp),RECNO(),recno('mytable')
>>  else
>>      go top in mytable
>>  ENDIF
>>endscan
>>

>>
>>Not found values have a rule ?
>>You can post
>>- expression m.orderExp and its type ?
>>
>>Fabio
>
>It's a free table. I haven't reindex yet. The value that I'm tring to seek is a compound index expression.
>
>The index is
>INDEX ON sono + STR(lineno, 4) TAG sono1
>The field defs are sono C(10), lineno N(4,0)
>
>I'm working on simplifying the code down to see if I can recreate in a less complex program.