Plateforme Level Extreme
Abonnement
Profil corporatif
Produits & Services
Support
Légal
English
File is in use by another
Message
De
23/04/1998 22:03:57
 
 
À
23/04/1998 09:18:19
Information générale
Forum:
Visual FoxPro
Catégorie:
Problèmes
Divers
Thread ID:
00094151
Message ID:
00094560
Vues:
23
>>I have a problem that I have never had before. I have a form that calls a modal dialog. The modal dialog SETS DATASESSION TO the calling form's id. After the dialog is closed, I insert some records into a view according to the contents of a cursor that the dialog modified. Everything is fine. I tableupdate the cursor. Still good.
>>But if I do the same thing and modify the newly added records (in a dataentry grid on the main form) and then save, any records that I modified are deleted in the view. Careful debugging shows that the tableupdate failed and AERROR shows "File is in use by another". The strange thing is, the next time I requery the view, the records are there, just without the changes. Does anybody have a clue as to what is going on? Please help, I have spent too many hours on this.
>
>Obvoiously, it's a conflict between two different datasessions holding the same records. I cannot say by sure why it's happened in you app, I feel there is some internal problem when there are too many private datasessions.

This is what I thought at first too, and is the reason I spent so much time tracking it down.
I was able to solve the problem by performing a requery() right after I tableupdate the view (the first time, after the records are added, but before they are edited). I am still not sure why this solved the problem, but it did.
Just when I think I've got all the nuts and bolts of buffering down, I get thrown a curve ball like this.

Thanks for your response anyway.
Erik Moore
Clientelligence
Précédent
Répondre
Fil
Voir

Click here to load this message in the networking platform