>Hi.
>I have an app where it appears that a Seek is not working intermiitently.
>I have a table as follows:
>
>Cur.MyField
>-----------------
>A
>B
>C
>D
>
>Which seeks another table
>Scan
> X=Cur.MyField
> Sele MyLookup
> Seek X Order MyOrder
> If Not eof()
> Do something
> Endif
>Endscan
>
>The seek on the third line of the Table above (C) sometimes gets a wrong record (e.g. might get B instead)
>This happens very infrequently (Maybe Twice a day out of 5,000 seeks)
>The Table taht is being Looked up is Locked ( as data nay be inserted and amended)
>The Lookup Table has about 30,000 records , with about 40 fields
Another possible cause is collate sequence other than machine on a non-character key. Any values which internal binary translation contains characters which fall under special cases (like accented ones, lowercase etc) may throw you off. Easy to check - just use the table and display status - if there's such a key, it would display along with the collating sequence.