| Is LOV updated every time the form runs ? [message #318876] |
Thu, 08 May 2008 06:06  |
golem1105
Messages: 6
Registered: April 2008 |
Junior Member |
|
|
I defined several lovs for one of the items. But after I modified some of the values manually in SQL plus the LOVs remain the same when I click the button. Are LOVs stored in a cache or something and not updated everytime they are called ?
Also, I've got another form inserting new records into one of the tables and after clicking the button the confirmation of insertion displayed, but I can't see the new record in SQL Plus. Is there a update time gap between SQL PLUS and form builder ?
Thanks !
|
|
|
| Re: Is LOV updated every time the form runs ? [message #318884 is a reply to message #318876 ] |
Thu, 08 May 2008 06:38  |
Littlefoot
Messages: 6007
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
|
You updated column values, but - did you COMMIT changes you've made? If you didn't do that, LoV can't see them. Besides, there's no "time gap".
|
|
|
| Re: Is LOV updated every time the form runs ? [message #318893 is a reply to message #318876 ] |
Thu, 08 May 2008 07:03 |
golem1105
Messages: 6
Registered: April 2008 |
Junior Member |
|
|
|
But i can see the new record in SQL-PLUS using select clause, do i still need to commit ?
|
|
|
| Re: Is LOV updated every time the form runs ? [message #318904 is a reply to message #318884 ] |
Thu, 08 May 2008 07:26 |
golem1105
Messages: 6
Registered: April 2008 |
Junior Member |
|
|
ok i see what you mean.
Thanks man !
|
|
|
| Re: Is LOV updated every time the form runs ? [message #318920 is a reply to message #318904 ] |
Thu, 08 May 2008 07:56 |
Littlefoot
Messages: 6007
Registered: June 2005
Location: Croatia, Europe |
Senior Member |
|
|
|
SQL*Plus is one session; Forms is another one. You have to commit changes in the first session in order to see them in another one.
|
|
|
]
Members
Search
Help
Register
Login
Home
