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
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.
answered 12 Sep '13, 08:38
Yalim Gerger ♦♦