Recent

Author Topic: How add a custom item for null values in DBLookupComboBox  (Read 2120 times)

juco

  • New Member
  • *
  • Posts: 11
How add a custom item for null values in DBLookupComboBox
« on: May 07, 2018, 03:33:57 pm »
I have a DBLookupComboBox linked to two Data Sources, one for the work query and another for the list, I need to add an additional element in the list (that does not exist in the query) that indicates when the KeyValue is null

Any ideas please?

juco

  • New Member
  • *
  • Posts: 11
Re: How add a custom item for null values in DBLookupComboBox
« Reply #1 on: May 07, 2018, 07:09:40 pm »
I do not know if the answer is the most appropriate, but in this way I got what I wanted

In the query for the list I added:

SELECT null As id, '(Empty)' AS description
UNION
SELECT id, description FROM rc_categories


 

TinyPortal © 2005-2018