OraFAQ Forum: Forms » Is LOV updated every time the form runs ?

Home » Developer & Programmer » Forms » Is LOV updated every time the form runs ?

Show: Today's Messages :: Polls :: Message Navigator
E-mail to friend

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 !

Report message to a moderator

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: 21823
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".

Report message to a moderator

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 ?

Report message to a moderator

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 !

Report message to a moderator

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: 21823
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.

Report message to a moderator

Previous Topic:	going into query mode problem
Next Topic:	tree in lov

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Feb 09 06:04:17 CST 2025