Field values not shown in smart client

Classic Servoy
1

Hello,

after creating a new record all fields in the form do not show their values in smart client. They seem to be empty.
In the database I can see, that the fields are not null.
The values has been set by method. The method calls

databaseManager.saveData();
application.updateUI();

without any effect.

I only have that problem with MS SQL Server Express 2012. With PostgreSQL there is no problem.
I cannot change the DB system. I tried to change the driver; from jtds to MS SQL jdbc driver. But without effect.

Does anybody of you has an idea?

Servoy Server 8.2.2 -releaseNumber 3107
java.version=1.8.0_161

Thank you and regards
Christoph

2

Hi Christoph,

Are you sure the fields have a dataprovider assigned?
You say the values are being set by a method? Is this done on the form’s foundset or on a foundset defined in the method itself?

3

Do not use the JTDS driver with MS SQL products. This driver has not been updated in years, and there are known issues when using it with MS SQL. Make certain you are using the latest MS provided JDBC driver. It works with all dialects of MS SQL.

I hope this helps!

4

Hello,

thank you for your answers!
I changed the driver and updated SQL Server to 2017. Unfortunately there was no change.

It has something to do with the sequence. Today I will have a look on this.

Regards
Christoph