Strange problem listed for solution after upgrade to 4.1.2

Questions and answers on designing your Servoy solutions, database modelling and other 'how do I do this' that don't fit in any of the other categories

Strange problem listed for solution after upgrade to 4.1.2

Postby msedita » Mon Apr 20, 2009 8:34 pm

After upgrading, when I open my solution in developer, the Problems tab shows error:

Valuelist 'client_group_cd' is based on column 'group_cd' from table 'c6grpdet' which is not found.

This is a related values list using two relations and three tables. I don't see a problem with it and it was not reported in previous versions.
User avatar
msedita
 
Posts: 224
Joined: Thu Dec 13, 2007 8:01 pm

Re: Strange problem listed for solution after upgrade to 4.1.2

Postby Hans Nieuwenhuis » Tue Apr 21, 2009 7:37 am

Hi,

I noticed this also and created a case for this a few days ago.
It has a sample solution te reproduce the issue.

Case : 206696

Regards,

Hans
Hans Nieuwenhuis
Betagraphics
http://www.deltics.nl
http://www.betagraphics.nl

Servoy Version 7.3.1
Java version 1.7.0.x
Database Oracle 11g
User avatar
Hans Nieuwenhuis
 
Posts: 1026
Joined: Thu Apr 12, 2007 12:36 pm
Location: Hengelo, The Netherlands

Re: Strange problem listed for solution after upgrade to 4.1.2

Postby martinh » Tue Apr 21, 2009 9:50 am

Me too, I got the error

I thought my valuelists were not defined correctly, but since I'm not the only one, I guess it is a new issue.

Also I noticed when you have once selected an item in the third box, but you don't have show in list / return as dataprovider selected, that Servoy still gives an error on the field selected (there is no empty field or -none- value)
If both show in list / return as dataprovider are unselected, selected field in third box should be ignored (I guess this should be the case also for the first and second box)

Another error:

Valuelist 'sec_users' is relation based so it should not specify table/server.

The radiobutton 'Related values' is selected. But in the 'All values from ' there is a server visible. I had to do that in the past because of bugs in the past in Servoy.
If the radiobutton 'Related values' is selected, then Servoy should ignore any value that is filled in 'Database values'
Or during the update from 4.1.1 to 4.1.2 the repository should had been updated so that the servername should have been cleared in case of 'Related values' selected.

Martin
Martin
------------------------------------------------
Servoy Developer
Version 5.2.10/5.2.13
Java version 1.6 update 31
Database SQL Server 2008 R2
martinh
 
Posts: 857
Joined: Wed May 09, 2007 5:34 pm
Location: Belgium

Re: Strange problem listed for solution after upgrade to 4.1.2

Postby Hans Nieuwenhuis » Tue Apr 21, 2009 9:58 am

Valuelist 'sec_users' is relation based so it should not specify table/server.


I had this to. But you can let Servoy repair this.

Simply select another column in the list and select the previous one again.
(This activates the save button)
Then Save and Servoy will ask you and remove the server entry.

Regards,

Hans
Hans Nieuwenhuis
Betagraphics
http://www.deltics.nl
http://www.betagraphics.nl

Servoy Version 7.3.1
Java version 1.7.0.x
Database Oracle 11g
User avatar
Hans Nieuwenhuis
 
Posts: 1026
Joined: Thu Apr 12, 2007 12:36 pm
Location: Hengelo, The Netherlands

Re: Strange problem listed for solution after upgrade to 4.1.2

Postby jcompagner » Tue Apr 21, 2009 12:23 pm

about the

"Valuelist 'client_group_cd' is based on column 'group_cd' from table 'c6grpdet' which is not found."

This is a developer only issue where the builder doesnt correctly work with valuelist build on n-m relations.
This will be fixed asap

For people who do want to export solutions and so on there is a work around:

Project menu -> deselect Build Automatically
Project-> Clean ..

in the Clean dialog disable the "start a build immediately" and press ok.

Now the errors are gone and you can export.

After that please enable build automatically else you will not receive feedback for other errors that could happen in a solution.
Johan Compagner
Servoy
User avatar
jcompagner
 
Posts: 8828
Joined: Tue May 27, 2003 7:26 pm
Location: The Internet


Return to Programming with Servoy

Who is online

Users browsing this forum: No registered users and 8 guests