Home » Developer & Programmer » Forms » Is LOV updated every time the form runs ?
Is LOV updated every time the form runs ? [message #318876] Thu, 08 May 2008 06:06 Go to next message
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 Go to previous messageGo to next message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
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 Go to previous messageGo to next message
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 Go to previous messageGo to next message
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 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
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.
Previous Topic: going into query mode problem
Next Topic: tree in lov
Goto Forum:
  


Current Time: Sat Dec 10 04:56:46 CST 2016

Total time taken to generate the page: 0.12969 seconds