Information générale
Catégorie:
Codage, syntaxe et commandes
Versions des environnements
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
Précédent
Suivant
Répondre
Voir le fil de ce thread
Voir le fil de ce thread à partir de ce message seulement
Voir tous les messages de ce thread
Voir tous les messages de ce thread à partir de ce message seulement