Value List Strange Behavior

Classic Servoy
1

Version: 4.1.2 - build 663
Sql Server 2005

I am having some strange things happen with valuelists in my solutions.

For example: I deleted a view from a sql server 2005 database. I then deleted the valuelist designed in Servoy that was based on the view. This changed the way the other valuelists in the solutions acted. One valuelist had the return in dataprovider field changed to another field. Other valuelists in the project did not show in the field after a selection was made from the dropdown combo box.

I have also noticed that when I reload data from database that the valuelists no longer work the way they did before the refresh. I can not pinpoint exactly when the strange behavior is happening. I would like to know if others are having issues with valuelists or if this is a possible bug.

2

What happens if you restart developer ? Is it still acting weird ?

3

Yes. I am using a table in the database with valuelist_name as the filter in the value list definition. I also have some value lists in the project that are based on views and some based on tables in another database on the server.

4

Here is an example of strange behavior. Below is a portion of my valuelist table in sql server. When I define the valuelist named vlSuffix in my solution to return code in data provider and show code in field list, when I select an item from the dropdown combo box, it will appear in the field. However, if I define the desc to show in field/list the value does not show when clicked from the dropdown. I have taken the period out of the desc column of the table and that did not change the behavior.

id desc code valuelist_name
262 Esq. ESQ vlSuffix
263 I I vlSuffix
264 II II vlSuffix
265 III III vlSuffix
266 IV IV vlSuffix
267 Jr. Jr vlSuffix
268 M.D. MD vlSuffix
269 Ph.D. PHD vlSuffix
270 Sr. Sr vlSuffix
271 V V vlSuffix

5

You don’t have any error(s) in the logs ? What type is column ‘desc’ and what type is the dataprovider of the dropdown (maybe they don’t match) ?

6

I did an rtrim(ltrim,(fieldname)) on both fields in the database and that valuelist now works, however another one does not.

Both fields for the dataprovider are text and the field in the table is text. I may have to find another way to handle this, because I have a deadline on the project I am doing. I see no errors in the log.

7

I am sorry, the field in the database table is Varchar(5)