>I have used seek() to look up information in huge tables (they were read only, no new records) and I was really pleased with it.
>
>Recently I have used seek() with tables updated frequently by a few users and also automatically by a program. It all works on WinNT net. Buffering and transactions are involved.
>
>I have encountered 2 problems which made me change seek() into select sql
>(problems happen occasionally so they are difficult to debug)
>
>1) seek() returns .F. while I know that a record exists and can be found for example by locate

Is the tag or order the one used by the seek: llRecordFound=seek("MyKey","MyTable","MyTag")?
Does the seek look for a partial key (EXACT OFF/EXACT ON)?
If another line of code did a SET ORDER or SELECTed another table - the SEEK line needs to assure proper table and tag.hth

>
> I think that index might be corrupted but no error happens.
> This problem appears when program works continuously for a few hours.
> Unfortunately reindex can not be used because it would slow down the program for too long.
>
>2) I get the error message "Update conflict".
> A debugger shows the line with seek()!!!
>
>I have solved my problems by using select sql instead. But I’m really curious what is going on. I would appreciate any comments.
>
>Thanks in advance
>
>Eryk Remiorz