2021.3.3.3645_LTS problem saving data to Foxpro db

Discuss all problems you have with Servoy here. It might help to mention the Servoy version and Operating System version you are using

2021.3.3.3645_LTS problem saving data to Foxpro db

Postby briese-it » Fri Jul 01, 2022 4:11 pm

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.
Michael Harms
Briese Schiffahrts GmbH & Co.KG, Germany
- Servoy 2020.3.3.3565_LTS Running on Windows 2019 DataCenter - MSSQL2017 & PostGreSQL
User avatar
briese-it
 
Posts: 171
Joined: Mon Jun 20, 2011 1:50 pm
Location: Leer, Germany

Re: 2021.3.3.3645_LTS problem saving data to Foxpro db

Postby jcompagner » Fri Jul 01, 2022 4:26 pm

what is the exception that you get (like after saveData() what does record.exeption tell you)?
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8829
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: 2021.3.3.3645_LTS problem saving data to Foxpro db

Postby briese-it » Mon Jul 04, 2022 8:08 am

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

Code: Select all
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.
Michael Harms
Briese Schiffahrts GmbH & Co.KG, Germany
- Servoy 2020.3.3.3565_LTS Running on Windows 2019 DataCenter - MSSQL2017 & PostGreSQL
User avatar
briese-it
 
Posts: 171
Joined: Mon Jun 20, 2011 1:50 pm
Location: Leer, Germany

Re: 2021.3.3.3645_LTS problem saving data to Foxpro db

Postby jcompagner » Mon Jul 04, 2022 9:39 am

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

databaseManager.nullColumnValidatorEnabled = false;
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8829
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet

Re: 2021.3.3.3645_LTS problem saving data to Foxpro db

Postby briese-it » Wed Jul 06, 2022 3:08 pm

Hi Johan,
perfect, that's it. I have never seen this option before :-). Many thanks.
Michael Harms
Briese Schiffahrts GmbH & Co.KG, Germany
- Servoy 2020.3.3.3565_LTS Running on Windows 2019 DataCenter - MSSQL2017 & PostGreSQL
User avatar
briese-it
 
Posts: 171
Joined: Mon Jun 20, 2011 1:50 pm
Location: Leer, Germany


Return to Discuss possible Issues and Bugs

Who is online

Users browsing this forum: Google [Bot] and 10 guests