Field values not shown in smart client

Questions, answers, tips and ideas on Servoy Client

Field values not shown in smart client

Postby cl@muc » Sat Mar 03, 2018 2:10 pm

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
Code: Select all
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
Christoph Langheld
http://www.project-print.de
cl@muc
 
Posts: 11
Joined: Thu Sep 28, 2006 9:55 pm
Location: Munich

Re: Field values not shown in smart client

Postby ROCLASI » Sat Mar 03, 2018 6:19 pm

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?
Robert Ivens
SAN Developer / Servoy Valued Professional / Servoy Certified Developer

ROCLASI Software Solutions / JBS Group, Partner
Mastodon: @roclasi
--
ServoyForge - Building Open Source Software.
PostgreSQL - The world's most advanced open source database.
User avatar
ROCLASI
Servoy Expert
 
Posts: 5438
Joined: Thu Oct 02, 2003 9:49 am
Location: Netherlands/Belgium

Re: Field values not shown in smart client

Postby kwpsd » Sat Mar 03, 2018 7:51 pm

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!
Kim W. Premuda
San Diego, CA USA
User avatar
kwpsd
 
Posts: 687
Joined: Sat Jul 28, 2007 6:59 pm
Location: San Diego, CA USA

Re: Field values not shown in smart client

Postby cl@muc » Mon Mar 05, 2018 9:07 am

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
cl@muc
 
Posts: 11
Joined: Thu Sep 28, 2006 9:55 pm
Location: Munich


Return to Servoy Client

Who is online

Users browsing this forum: No registered users and 4 guests