Difference valuelist.ini in dataface version 0.5.4/0.6.9r1 ?

[sym]

Dear dataface users,

First of all, Steve thanks for the new version of Dataface with the new functions.

Purpose:
With the file valuelist.ini i 'renamed' the ID into a username, but i will only display the names of a certain group


file: valuelist.ini
EMPLOYEES_BUSINESS]
__sql__ = "SELECT DISTINCT EMPLOYEE_ID, EMPLOYEE_LASTNAME FROM EMPLOYEES_BUSINESS where EMPLOYEE_LOCATION = 'G' "


Problem/Question:
In dataface version 0.5.4 it works fine, i only saw the id/name combination which are in that group displayed.
In version 0.6.9r1 i see also blank lines (with a clickable + sign in front) which are not belonging to that group.

I tried also the mysql join statement, but i get the same output.
Do i something wrong or must i do it on a other way in the new version ?


Best regards,
Nico Sijm

[shannah]

Hi Nico,

There shouldn't be any compatibility problems from 0.5.x to 0.6.x as far as valuelists are concerned. Are these blank lines showing up in list mode or browse mode (on the form)?

-Steve

[sym]

Hi Steve,

So, youre fast! Thanks for the reaction.

I see the empty lines in the list mode.

Ik have the idea that in the 0.6.x version always the clicable + referention, even if the result of the sql statement is empty, is dislayed.
The clicable + gives information about that cell (this is new comparing with the 0.5.x version) and i see in my case that EMPLOYEE_LOCATION = 'U' and this cell should not be displayed.

I can mail you the screen dumps of both versions, if this make it more clear.

Best regards,
Nico Sijm

[shannah]

Yes.. screen shots would be helpful.

Also, if you can provide the relevant portions of the database schema and fields.ini files, that might help me to debug on this end.

Best regards

Steve