I've been struggling to use a LOVFIELD in a datagrid. I want the datasource to store the ID (number) value, but the lovfield to show the name, both in the LOV pop up and the datagrid.

So, the column in the datagrid shows the name, when typing, the validation shows up the lov component with the name, but on the background, only the ID is stored.

I have tried every combination I can think of but I'm not getting there.

Thanks and regards

asked 21 Dec '14, 05:57

stijnh's gravatar image

accept rate: 0%

Found solution. Use view as data source that combines the ID from the source table and the name from the lookup table. Make sure the name column is not updatable in the data source definition Create LOVFIELD in the datagrid with: value = ID column = NAME bindvariable = NAME(bind variable in LOV) LOV= name of LOV

This allows me to search on the name and the ID is stored in the source table.

Pretty textbook I'm sure but might help other beginners like me.



answered 22 Dec '14, 03:18

stijnh's gravatar image

accept rate: 0%

in my case i had to set the name column to updateable in the datasource definition to get it to store the ID to source table


answered 07 Aug '15, 02:52

Nicholas%20M's gravatar image

Nicholas M
accept rate: 0%

Your answer
toggle preview

Follow this question

By Email:

Once you sign in you will be able to subscribe for any updates here



Answers and Comments

Markdown Basics

  • *italic* or _italic_
  • **bold** or __bold__
  • link:[text](http://url.com/ "title")
  • image?![alt text](/path/img.jpg "title")
  • numbered list: 1. Foo 2. Bar
  • to add a line break simply add two spaces to where you would like the new line to be.
  • basic HTML tags are also supported



Asked: 21 Dec '14, 05:57

Seen: 1,503 times

Last updated: 07 Aug '15, 02:52

© Copyright Gerger 2017