>>>Does anyone know why a seek(value,table,index) would cause a "uniqueness of index" error.
>>>The index is the PK. Table is buffered. I thought the uniqueness error was only if it was being updated.
>>>Isn't the seek just a optimized lookup? The table's PK has a related table.
>>
>>Is the table record-level buffered? If yes, then seek will cause a record movement and if you added a new record, it will try to commit it.
>>
>>Try using INDEXSEEK instead or use table-buffering (buffering = 5)
>
>I do use table-buffering = 5 and I want the pointer to move so I can capture other data related to the found record.
I think you may want to post some relevant code then.
If it's not broken, fix it until it is.
My Blog