Value list problem

Hi,

I’m having a strange problem: I set a valuelist based on db values:

1st field: operatorid, return in dataprovider, don’t show
2nd field: name, show
3rd field: last name, show

Separator char: a space.

Servoy (2.0) doesn’t seem to keep the setting and, every time I restart the application, the valuelist shows values like:
JohnNULLSmith
JanNULLAleman
HomerNULLSimpson

I’m having this problem when I moved the solution from MySQL to Sybase.

OSX.3.3

Sybase can not differenciate between a space and NULL, this will be fixed in Servoy 2.01

Jan Blok:
Sybase can not differenciate between a space and NULL, this will be fixed in Servoy 2.01

Thanks, Jan :slight_smile:

I am having the same problem using Servoy 2.0, connecting to a mysql database. Will this also be fixed in v.2.01?

i have never seen this happening on MySQL DB.
What version of servoy and mysql driver, database are you using?

Are you also seeing this when using 2.1RC4?

I am using MySQL 4.0.20, and servoy R2 2.0-build 273.

please test a newer build.
The best build to use is currently 2.1RC4. It is very close to the final