It's a private datasession and PESHPACT is the name of the view (the alias name in the DE). So you think that the select statement is part of the internal VFP default mechanism?




>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