Home » Developer & Programmer » Forms » Lov Problem (Windows XP DB 9i - forms 6i)
Lov Problem [message #384113] Mon, 02 February 2009 03:34 Go to next message
*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh
Senior Member
Hi Guyz,

I have some problem with my form, i need to use lov what ever user insert in the previous text_item

here is the scenario.

i have dept_name in my module and lov button with the below code.

declare
lov boolean;

begin

lov := show_lov('lov58');

end;


with the above code i can call lov but before calling this lov i have one more field called dept_name in my module i want to fetch the records as per this dept_name whatever user enter in this item it will show the related to this dept_name if dept_name not found display a message.

anyone help me in this regards

waiting for the response.

Regards


Re: Lov Problem [message #384118 is a reply to message #384113] Mon, 02 February 2009 03:43 Go to previous messageGo to next message
Littlefoot
Messages: 20891
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Obviously, list of values' record group's SELECT statement has to reference "dept_name" item.

As you don't want to show LoV if dept_name is empty, include that condition into the trigger:
declare
  lov boolean;
begin
  if :dept_name is null then
     message('Department name must be entered');
     raise form_trigger_failure;
  else   
     lov := show_lov('lov58');
  end if;
end;

Alternatively, make the "dept_name" a required item.
Re: Lov Problem [message #384122 is a reply to message #384118] Mon, 02 February 2009 03:47 Go to previous messageGo to next message
*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh
Senior Member
obviously dept_name is mandatory, but what about the user insert some record in the dept_name how can i achive that name with LOV?

sorry i didnt read you first line before.

could you please give me some syntax little about the below
list of values' record group's SELECT statement has to reference "dept_name" item



Regards

[Updated on: Mon, 02 February 2009 03:56]

Report message to a moderator

Re: Lov Problem [message #384128 is a reply to message #384122] Mon, 02 February 2009 04:11 Go to previous message
*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh
Senior Member
Thanks for support.

i solved...

Regards

Moazam
Previous Topic: dynamic list errors
Next Topic: regarding error
Goto Forum:
  


Current Time: Sun Dec 04 17:06:25 CST 2016

Total time taken to generate the page: 0.05615 seconds