A form based on a view calls another form to add a record. The first form deletes the record. TableUpdate() returns 1585: Update conflict. If, instead of adding just one record, then deleting it, I add a record, then add another, the problem doesn't occur. The rest of this message assumes the first scenario: add-delete-error.
The view has a buffermode of 5. The underlying table has a buffermode of 1. The form's buffermode is 1 or 0 (no difference). The second form's datasession is private. On returning from the second form, the view is requeried. Browsing the view and the underlying table right before the delete shows the (single) record exists in both tables.
I've considered all the obvious things, I think. The fact that add-add-delete-delete works, where add-delete doesn't is what makes this weird.
I've "fixed" the problem by closing the underlying table right before requerying the view. Then the requery opens it again and all is well. It's almost like there was some buffering of the underlying table going on that only is apparent when the view contains no records.
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only