>>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