Repeated a flawed situation

[Fred Slota]

So, I'm going through and adding "Box xxx" identifications into Custom Field 2 as I do my yearly Grand Unification, and I've done something multiple times now that is really bad, and I don't know fully what is happening, but want to describe it in case th is some protection that can be added against it.

 

At the moment, I'm identifying issues in a waiting box, so I'm scanning individual issues and pasting "Unread Old 001" in Custom Field 2.  Zap a book, click on Custom Field 2, Ctrl-V, focus on Find bar, rinse repeat.

 

The problem occurs if I zap a book and press Ctrl-V without clicking on Custom Field 2.  The first columns, which has a header icon of a right arrow in a circle, gets filled with a number of dingbats, the thumbnail is replaced with a red X-box, and a number of error windows pop up.  Worst, the entry eventually disappears.

 

I've pulled the three issues where this happened.  I have not yet done a repair.  I'm not worried about recovering the entries.  I am concerned that such an innocent mistake can corrupt database information.

[Fred Slota]

Incidentally, the entry doesn't 'disappear'.  I've closed and reopened that database a couple times, and I now notice that in those titles, instead of the effected entry, I now have an entry for issue number "Unread Old 001", where every text field has the value "Unread Old 001". 

Which, I guess makes sense. 

In the above error, instead of clicking on a field and Ctrl-V'ing text into a single field, I Ctrl-V'ed while the entire row was selected.  Normally, typing a number, your focus ends up in the Quantity field.  Accidentally using a scanner to scan another UPC, your focus also ends up in the Quantity field.  But, somehow, Ctrl-V'ing with text appears to result in attempting to paste the text in all the fields for the entry, even fields that don't make sense for text like numbers and the cover scan.

I strongly suggest that ComicBase figure out a way to detect that this is about to happen and prevent it in the future.