Validation failed for 'FieldName', with value: null

Classic Servoy
1

Hi,
I’m using a MS-SQL-Database. Only datetime-fields allow NULL-values.

Now, when I step from field to field on an form, by pressing TAB, I get the following error when a field is empty:

Validation failed for ‘email’, with value: null

java.lang.IllegalArgumentException: Validation failed for ‘email’, with value: null

What is wrong?

Thanks for Info
Harro

2

You shouldn’t get any error until you try to save to the DB, are you saving on onFocusLost of the fields? If autosave is turned on it should save only when you click outside the fields, not when you move from one to another.

3

as nicola is saying that exception you shouldn’t get when tabbing over fields… That is not the db complaining but servoys null check, but still that shouldn’t happen when you don’t change anything…

4

what if You use databaseManager.nullColumnValidatorEnabled = false;

I set this in the onOpen method of my solution