Servoy Forum

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.

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

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

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

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.