So using standard networking code for tables and forms, do the templates/library code leave a hole in the integrity of the system whereby data can be lost as follows?
- User 1 presses INSERT to create a new autoincrement record
- User 2 sees the “dummy” record and double clicks to edit it. Fills it in, maybe adds child records. Possibly goes in a few times adding even more info and perhaps printing it etc.
- User 1 comes back to their screen and hit ESC or clicks cancel - this deletes the record!
Of course, if two users EDIT the same record, the templates/library code check for “changed by another station” - but not in the above scenario!
Is this indeed the way the system is, and if so, has anybody already dealt with it cleanly (templates/class improvement) and is willing to share?
(I would try to have the CANCEL check for changes in the record on disk and/or at least warn users not to edit anything that looks like a dummy record that might still be in the process of being inserted.)