>It's a private datasession and PESHPACT is the name of the view (the alias name in the DE).

I doubt about that. Usually there are default names like "Cursor1" unless you explicitly rename the cursor.

>So you think that the select statement is part of the internal VFP default mechanism?

I do not know. It may depends on the definitions and structure of the view/dbf/database that are in use.

Anyway, if you are sitting on the proper table and on the proper record, then you do not need to add "IN" while replacing.

>
>
>
>
>>If form has a private datasession, then it uses the updatable view/cursor of a table, not table itself, and there is a default mechanism for table update etc.
>>Most likely you need to replace in the view, and then issue tableupdate. The name of the view you can get from the form.dataenvironment.
>>
>>
>>
>>>Hi everyones,
>>>
>>>A client of mine got an error which I don't understand.
>>>It says "record in use by another user " this I understand although I'm not sure it was true.
>>>
>>>Then it gives me the method and the line, in my code the line is this :
>>>REPLACE nK WITH lnK, nKTrans WITH lnKSeason IN PESHPACT
>>>
>>>I'm updating the current record in the table PESHPACT, it's sort of make sense with the error and I'm ok with that.
>>>
>>>But at the very end it shows this line as information, which I don't understand :
>>>
>>>SELECT PESHPACT.cShpActID,Recno() as cRecNo FROM PESHPACT ORDER BY PESHPACT.cShpActID into cursor Viewcalv96
>>>
>>>How can a REPLACE statement be translated into a select statement, is it something VFP is doing by itself?
>>>
>>>BTW, the form has it's own datasession, the table PESHPACT is in buffer mode 5 and all indexes are define as regular index, so VFP doesn't really know what is the unique key in this table.
>>>
>>>Thanks
>>>Diane Robitaille