Denis
open table
I do not care about the app. The question was: Was it open in your datasession?

buffering
Question remains, is the table buffered? I can not look into your form. (Aside: what property of the form is setting this?)
Use CURSORGETPROP function the check this. Only the return you get next to the UPDATE is of any value.

Lutz

>>Hi Denis
>>
>>This is a DBF?
>yes
>
>>Is there only one database?
>yes
>
>>Is the database active?
>yes
>
>>Was to table open?
>I use Stonefield Database Toolkit. All the tables are opened when the app starts.
>
>>You are the single user?
>Yes
>
>>Is the table buffered?
>Use form setting
>
>>
>>All my idea would be to run VALI DATA; check if the index is corrupted. Open the table outside the database without index, DELETED OFF and look for duplicates in the pk. Rebuild index (possibly from scratch)
>>
>>Lutz
>>
>>>Hello all,
>>>
>>>Sometimes I get this error in an update.
>>>
>>>

>>>UPDATE CliCommandProd ;
>>>	SET PaieFait = .t. ;
>>>	WHERE PrimaryKey = iPrimaryKey
>>>

>>>
>>>Data session is private in one form and default in another form
>>>
>>>Is it because I don't specify the database before the name of the table?
>>>
>>>If not what am I doing wrong?
>>>
>>>Regards