2021.3.3.3645_LTS problem saving data to Foxpro db

Feedback
1

Hello,
I upgraded to 2021.3.3.3645_LTS and now it’s not possible to write data to a foxpro database using the hxtt driver.
The foxpro tables have null parameters disabled so the null values ​​are not written or empty. This worked without any problems with the older Servoy LTS versions.
Now databaseManager.savedata() returns false and no more records are inserted or updated.

2

what is the exception that you get (like after saveData() what does record.exeption tell you)?

3

Hi Johan,
it tells me that columns can’t be null. As example:

ERROR com.servoy.j2db.util.Debug - com.servoy.j2db.dataprocessing.DataException: Column data not valid, null check or other database validation failed
Column uid_prev can't be null

Columns can’t be null, that’s correct but normally it should return empty instead null to the foxpro database. Now I bought the actual hxtt drivers but the same story.

4

so you do have that uid_prev assignd as an empty string?
maybe you can try todo this:

databaseManager.nullColumnValidatorEnabled = false;

5

Hi Johan,
perfect, that’s it. I have never seen this option before :-). Many thanks.