>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.
Edward Pikman
Independent Consultant