Hello all,
I have a situation regarding servoy validatoin for fields marked as not "Allow Null".
I have a form based on a table. the two fields on the form are not nullable. One is a drop down, the other is a text field
a) if we don't set any values and click a button to "Save" the data, we can trap the error and display our own error message to the user.
b) if we set the drop down value and leave the text value untouched we can trap the error and display our own error message to the user
c) if we delete the text value and leave the drop down value we can trap the error and display our own error message to the user
here's were it gets weird.
1) set both values.
2) set the drop down to an empty value.
the drop down goes red
3) Click ok, nothing happens. The form appears locked.
the server log shows:
Error Handler (Non-Oracle error): Invalid input, Validation failed for 'field_name', with value: null User: user@0:0:0:0:0:0:0:1 Form: Element: Servoy Error Code: 310
4) now set the drop down to a value and clear the text
5) try to click okay, the text field retains focus and similar error is displayed in relation to this field value.
I can see that servoy is trying to handle this issue, problem is the user has no idea whats happening behind the scenes as our dialog won't be displayed anymore.
Could someone explain what might be going on? and how do I get around this issue?
Thanks
Servoy Version: 5.2.7 - build 1013
Windows XP/7
Firefox Version 3.6.16