jannes
2015-01-05, 10:18
A listbox doesn't show an empty row when browsing through data.
The last entered choice is displayed on every row with a null value.
Choices : SELECT omschrijving FROM titel ORDER BY omschrijving
Getdatamapping : keylookup("titel", "titel", nvl("{}","$%"), omschrijving)
Setdatamapping : keylookup("titel", "omschrijving", "{}", titel)
This does work :
Getdatamapping : keylookup("titel", "titel", nvl("{}","$%"), omschrijving, "<empty>")
But we don't want to display "<empty>", an empty field (spaces) should be displayed.
This doesn't work either :
Getdatamapping : keylookup("titel", "titel", nvl("{}","$%"), omschrijving, "")
Getdatamapping : keylookup("titel", "titel", nvl("{}","$%"), omschrijving, " ")
Getdatamapping : keylookup("titel", "titel", nvl("{}","$%"), omschrijving, chr(32))
The last entered choice is displayed on every row with a null value.
Choices : SELECT omschrijving FROM titel ORDER BY omschrijving
Getdatamapping : keylookup("titel", "titel", nvl("{}","$%"), omschrijving)
Setdatamapping : keylookup("titel", "omschrijving", "{}", titel)
This does work :
Getdatamapping : keylookup("titel", "titel", nvl("{}","$%"), omschrijving, "<empty>")
But we don't want to display "<empty>", an empty field (spaces) should be displayed.
This doesn't work either :
Getdatamapping : keylookup("titel", "titel", nvl("{}","$%"), omschrijving, "")
Getdatamapping : keylookup("titel", "titel", nvl("{}","$%"), omschrijving, " ")
Getdatamapping : keylookup("titel", "titel", nvl("{}","$%"), omschrijving, chr(32))