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
Diane Robitaille eng.