Hi Harry,

Do you have table or row buffering enabled for EMESSAGES cursor? If you do then the result of the INSERT is buffered and indexes are not updated until you force the record to be committed either into table or into table buffer (simple GO RECNO() will do).

Thanks,
Aleksey.



>Aaarggh!!
>
>How is this possible?
>I insert data into a file thus:
>INSERT INTO emessages FROM MEMVAR
>If I then check
>
>?INDEXSEEK(M.MESSAGEID,.F.,'EMESSAGES','MESSAGEID')
>
>it fails every time.
>
>In order to force it to recognise the new record exists I have to select the alias
>change the order
>and seek the record (or go reccount())
>
>only after that will
>INDEXSEEK(M.MESSAGEID,.F.,'EMESSAGES','MESSAGEID')
>return .t.
>
>there are no filters active.
>
>the only clue I can offer is that this data insertion is taking place during an online session (I'm retrieving email messages and the object is to delete any messages I've downloaded, but I thought it prudent to check that they are properly saved before deleting. This bug means none get deleted until the NEXT online session, by which time the indexseek works...)
>
>Does an online session somehow temporarily hide foxpro's ability to read new insertions?
>
>or what?