Valuelist + Combobox trouble..

Classic Servoy
1

I have 3 Comboboxes - based on local mysql valuelists.

The problem:

If i set them via the drop down menue or via script, i get in 90% a blank combobox field if i reload the form or exit & restart the application.

I checked the database directly and the values are written everytime correctly into the database. Only the drawing of the comboboxes seems not to work, since i get very often blank boxes.
The problems have not been seen here in the latest beta releases - only in the final version.

Any idea ?

Rainer

2

Can you post an example solution that shows this behaviour? If it contains proprietary information you can email it to support@servoy.com.

3

down to the redraw of the Combobox.

As i mentioned already the values a correctly saved into the mysql database but not correctly shown in the combobox ( maybe the box does not get the values correctly / or it is a redraw problem).

I validated the bug by using the same dataprovider as:

Comobox = Empty ( value not displayed / white box)
Radio = correctly selected
Ceckbox = correctly selected
Text = Value of the choosen Valuelist = ok.

Unfortunately my solution is too complex ( multiple internal / external databases ) to mail.

I use this (basic) setup: ( all mysql based )

A table with the name shipping_methods:

  • Field: shipping_method ( Text )
    with five Records ( containing the different methods)

A value list shipping_valuelist

  • based on all records of the shipping_methods table above..

A tabel with the name Table_oders:

  • Field: orders_shipping_method ( Text )
    Combobox based on the above valuelist

As mentioned, if i replace the combobox with a radio/checkbox etc. everything is fine.

Rainer

4

We are unable to reproduce this in the sample crm, so please post a small solution prefereable with some sample data.

5

I made a small solution and have tracked my problem down.

The problem of the boxes not loaded are due to a find command.

If i set a field value with a combobox to value “X” ( e.g. of record id #7) everthing is ok.
I can browse to other records and back and the combobox has still its value.
If i now use the find command and search for record id #7 the combobox in the found record is blank, even if the data in the database is correct. ( verified with same dataprovider as Text, Radio, etc..).

Rainer

6

fixed it for 2.0.1

7

..even on weekends..

Rainer BM-vhm