>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.
Charles
"The code knows no master." - Chuck Mautz
"Everybody is ignorant, only on different subjects." - Will Rogers