Calum,

It could also look like it is executing with DELETED OFF.

Also, are EXACT and NEAR set in the correct datasession?
Are you using the FOUND() function?
good luck,

JimN

>Hi folks
>
>I'm having a bit of problem using SEEK. Heres what I'm doing
>
>1. Table buffering, 5
>2. set near off
>3. set exact off
>
>A. open table, delete a few records, do an sql - deleted records found! i.e its not taking into account the deleted records in the buffer until I issue tableupdate() - I can live with this but not sure why it should be doing this and not taking into account the buffer data.
>
>B. However this is whats driving me up the wall!
>open table, delete a few records, do a SEEK for the deleted record and expect not to find anything and go to EOF (in which case I do an append blank) BUT its not going to EOF, its actually sitting on a different record which means my replace code is replacing the wrong record!!!!
>
>It seems to be behaving as if SET NEAR ON ...
>
>I can only get B to work as I want if I do a TABLEUPDATE(.t.) after deleting the records and prior to issuing the SEEK.
>
>
>Any help would be apprecicated... it mught stop me pulling out the last few folicles I have !!!
>
>Calum