I’m having a problem displaying a valuelist generated from all (unique) values in a specific MySQL varchar column/field. Although I’m a relative novice at Servoy, I have been successful doing this in the past with an earlier version of Servoy w/ MySQL. The correct server and table are specified with only values from one column to select/display. When exiting the design mode, the combobox displays the current value, when the dropdown is selected the value goes temporarily empty and no additional values are displayed.
Any insight would be appreciated. Custom valuelists work fine.
- are you sure that the connection to the server/table where the valuelist is pointing to is alive?
- Did you doublecheck the settings of your return and display values in the valuelist dialog?
- Does the return value (varchar) of your valuelist corresponds with the datatype of the field it’s attached to?
- If you open(rightclick) your servoy_developer.bat, activate the stacktrace by adding “-DSTACKTRACE=true”,
and start up Servoy with this bat file, You can monitor the SQL statements and see if any errors occur.
java -Xmx256m -Xms64m -DSTACKTRACE=true -classpath servoy_developer.jar Servoy