Hi,

Lots of control on that form, page frame with 6 pages, grids etc. Some are link to views but none to an SQL statement as a record source. There could be a relation setup in the dataenvironment of that form, and other forms as well, using cShpActId as a key between tables.

Does the cursor name "Viewcalv96" ring a bell? I check the whole code using filer.scx and it's not there.


Diane




>>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
>
>What controls you have in the form? Did some of them use SQL Statement as a record source?