OraFAQ Forum: Forms » Lov Problem

Home » Developer & Programmer » Forms » Lov Problem (Windows XP DB 9i - forms 6i)

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

Lov Problem [message #384113]

Mon, 02 February 2009 03:34

*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

Report message to a moderator

Re: Lov Problem [message #384118 is a reply to message #384113]

Mon, 02 February 2009 03:43

Littlefoot
Messages: 21826
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.

Report message to a moderator

Re: Lov Problem [message #384122 is a reply to message #384118]

Mon, 02 February 2009 03:47

*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

*munnabhai*
Messages: 157
Registered: March 2008
Location: Riyadh

Senior Member

Thanks for support.

i solved...

Regards

Moazam

Report message to a moderator

Previous Topic:	dynamic list errors
Next Topic:	regarding error

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 30 19:49:50 CDT 2026