Data Validation Error message box pops up 4 times (OpenInsight 32-Bit)
At 20 DEC 2010 05:33:30PM Dietrich Neuman wrote:
Has anyone else encountered this? I'm running OI 9.2, and this happens with every form that I create against one of our OI (originally AREV) data tables (I can reproduce it by creating new form with either of 2 data tables I can name): I bring up the form, and I type in invalid data to a field, such as garbage text to a Date-Time field, then hit ENTER or click on a different field, and it pops up the "Data Validation Error" message box not once 4 times, one after the other. Haven't found any mention of this behavior in the WORKS forum of the Issue Tracking system. Anybody have any idea what's going on?
At 21 DEC 2010 08:15AM Sean FitzSimons wrote:
Deitrich,
Do you have a Validation pattern and LOSTFOCUS code on the fields in question?
I ask because I wonder if the form is validating the fields through the validation pattern and then executing your LOSTFOCOUS code and processing another validation.
Also is there anything on the GOTFOCUS code of the control receiving focus that could cause another validation.
One last thing… are there symbolics that are being processed incorrectly and throwing off the validation on the symbolic fields.
Sean
At 28 JAN 2011 05:56PM Dietrich Neuman wrote:
That's it. It was caused by two LOSTFOCUS promoted event subroutines (one for EditLines, one for general controls) that I ended up not even using. When I commented out the Forward_Event call i both of those promoted event handlers, it worked fine – the Validation Error message box only came up once.
Now I'm going to figure out how to remove those promoted event handlers… assuming I'd end up with cleaner code than just leaving them there…