Home » Developer & Programmer » Forms » Why do i need to refresh the lov's,if tables are recreated?
Why do i need to refresh the lov's,if tables are recreated? [message #85637] Thu, 15 July 2004 01:21 Go to next message
sudhir
Messages: 20
Registered: November 2000
Junior Member
Hi, all

I have created some LOV(at design time),in some of my screens

when ever i am dropping all the tables and recreating, and after that if i try to invoke the lov's in the screen, for the corrosponding LOV columns it say's that

frm-40212 - invalid value for the field

though it was working fine before recreating the tables

but if i  refresh that LOV (invoking the LOV wizard and just refreshing the query), it again works fine. 

I want to know that do we need to refresh the lov's(created at design time) if the tables are re-created.

Please guide me

Sudhir

 

Report message to a moderator

Re: Why do i need to refresh the lov's,if tables are recreated? [message #85647 is a reply to message #85637] Thu, 15 July 2004 17:25 Go to previous message
Zain
Messages: 30
Registered: October 2003
Member
Verify that the AUTOMATIC REFRESH property of the LOV is not checked off. It should be set to yes if you want the LOV query to execute each time it is invoked.

Report message to a moderator

Previous Topic: Transfer to 9i
Next Topic: Its URGENT ! PLZ . HELP ANYBODY !
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Jan 31 20:44:48 CST 2025
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.