Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
File is in use by another
Message
From
23/04/1998 22:03:57
 
 
To
23/04/1998 09:18:19
General information
Forum:
Visual FoxPro
Category:
Troubleshooting
Miscellaneous
Thread ID:
00094151
Message ID:
00094560
Views:
22
>>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
Previous
Reply
Map
View

Click here to load this message in the networking platform