Results 1 to 5 of 5

Thread: How to display null values in choices

  1. #1
    Junior Member
    Join Date
    Aug 2014
    Posts
    5

    How to display null values in choices

    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))

  2. #2
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,726
    Choicelists had an enhancement added to them so that if the SQL SELECT started with a + then a blank entry was added as the first entry in the list.

    It sounds like that was not added to the listbox. Please submit an ER that being the case.
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  3. #3
    Junior Member
    Join Date
    Aug 2014
    Posts
    5
    Thnx.

    Do you mean :
    SELECT + omschrijving FROM titel ORDER BY omschrijving

    or

    + SELECT omschrijving FROM titel ORDER BY omschrijving

  4. #4
    Lianja Development Team barrymavin's Avatar
    Join Date
    Feb 2012
    Location
    UK, USA, Thailand
    Posts
    5,726
    The second one.

    +SELECT ...
    Principal developer of Lianja, Recital and other products

    Follow me on:

    Twitter: http://twitter.com/lianjaInc
    Facebook: http://www.facebook.com/LianjaInc
    LinkedIn: http://www.linkedin.com/in/barrymavin

  5. #5
    Junior Member
    Join Date
    Aug 2014
    Posts
    5
    Thnx, it works OK.

Bookmarks

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Journey into the Cloud
Join us