Home » Developer & Programmer » Forms » oracle form (Oracle form 9i)
oracle form [message #389910] Wed, 04 March 2009 01:36 Go to next message
laith
Messages: 41
Registered: December 2008
Location: U.A.E
Member
i have 2 fields (term_code ,log_number), i'm trying to write code for LOV in the log number feild that when term code is empty ...showing me all the term_code records.how can i do that !! thank you for your help.
Re: oracle form [message #389919 is a reply to message #389910] Wed, 04 March 2009 02:26 Go to previous message
Littlefoot
Messages: 20901
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
What do you want to display when TERM_CODE is not empty?

In the meantime, here's a lucky guess:
SELECT t.col_1, t.col_2, ...
FROM your_table t
WHERE t.term_code = NVL(:block.term_code, t.term_code)
Previous Topic: Unable to highlight/select data(using mouse) on Oracle forms 10g on Vista client
Next Topic: FRM-30454: Unsupported item type.
Goto Forum:
  


Current Time: Fri Dec 09 23:26:09 CST 2016

Total time taken to generate the page: 0.04964 seconds