Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Strange error message - any ideas
Message
From
15/12/2005 15:14:03
 
 
To
All
General information
Forum:
Visual FoxPro
Category:
Coding, syntax & commands
Title:
Strange error message - any ideas
Environment versions
Visual FoxPro:
VFP 6 SP5
OS:
Windows 2000 SP4
Database:
Visual FoxPro
Miscellaneous
Thread ID:
01078433
Message ID:
01078433
Views:
54
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.
Next
Reply
Map
View

Click here to load this message in the networking platform