Hi, after digging deeper into formspider, i am troubling using LOV. it's possible that LOV inside grid return value to non database column ?

example i have two field one is for code and one is for description, code is database column but description isn't. what i want to achieve is if user choose one value in LOV, then the code value goes to Field code and the description value automatically display on the description field.

in oracle form it's easy to achieve, but using formspider i cannot assign the value to no datasource item if I using grid. I had try assign it using component it's doesn't work or i missing something..

Thank you for you big help.

asked 12 Sep '13, 07:53

Huwardi's gravatar image

accept rate: 0%

Hi Huwardi,

There indeed seems to be a bug for the case you have described. If the non-database feild is in a Grid then the LOV in a Grid cannot populate it.

I created an issue in our bug tracking system for this. Until we fix this issue, I suggest you do one of the two possible workarounds:

1) Bind the non-database field to a new dummy Datasource column (just add a dummy column to your query). Make sure that this new dummy Datasource column's Updateable checkbox in unchecked in the Datasource Definition Column screen.

2) Move the non-database field outside the Grid.

Personally, I'd prefer doing the 1.

Hope this helps.

Kind Regards,


answered 12 Sep '13, 08:38

Yalim%20Gerger's gravatar image

Yalim Gerger ♦♦
accept rate: 15%

Thank You Yalim,

I decide to create a new column in order to store and display the description, at least until the next LOV enhance.

(12 Sep '13, 23:26) Huwardi
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: 12 Sep '13, 07:53

Seen: 1,041 times

Last updated: 12 Sep '13, 23:26

© Copyright Gerger 2017