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.
Erik Moore
Clientelligence