OraFAQ Forum: Forms » How can i create an LOV that should not run if item field is not NULL

Home » Developer & Programmer » Forms » How can i create an LOV that should not run if item field is not NULL (FORMS 6i)

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

How can i create an LOV that should not run if item field is not NULL [message #311311]

Fri, 04 April 2008 01:13

gajendra
Messages: 8
Registered: April 2008
Location: INDORE

Junior Member

HI,
can any one give me the code to create LOV. which should not run if field is not NULL but LOV run if field is NULL.

sample code:

if blk.item is null then

if show_lov(lov_item) then
next_item;
end if;

else

if blk.item is not null then
next_item;
end if;

end if;

this is not working.

so suggest me any solution as soon as possible.

[Updated on: Fri, 04 April 2008 02:02]

Report message to a moderator

Re: How can i create an LOV that should not run if item field is not NULL [message #311377 is a reply to message #311311]

Fri, 04 April 2008 05:19

athar.fitfd@hotmail.com
Messages: 193
Registered: October 2007
Location: pakistan

Senior Member

Create an lov by lov wizard. then go to property pallete of field to which the lov is attached and set the lov property to null so that lov is not displayed when user presses F9 key.
Go to key next item trigger of the field and
write this code;

declare
lov boolean;
begin
if item1 is null then
lov:=show_lov('lov_name');
end if;
next_item;
end;

it will work .

ok bye.

Report message to a moderator

Re: How can i create an LOV that should not run if item field is not NULL [message #311600 is a reply to message #311377]

Sat, 05 April 2008 00:21

gajendra
Messages: 8
Registered: April 2008
Location: INDORE

Junior Member

Thanks very much for code it is working as per requirement.

i want to ask you something why you take boolean in this and can you explain how it is working.

[EDITED by LF: removed question which doesn't belong here; besides, there's a new topic opened for the same (which is the correct way to do it)]

[Updated on: Sat, 05 April 2008 03:43] by Moderator

Report message to a moderator

Re: How can i create an LOV that should not run if item field is not NULL [message #311628 is a reply to message #311600]

Sat, 05 April 2008 03:34

Littlefoot
Messages: 21818
Registered: June 2005
Location: Croatia, Europe

Senior Member
Account Moderator

Boolean? Where? If you are referring to "IF something > something_else" or similar, isn't it always a Boolean expression? "If something is true then do something", "if something is false then do something else" etc.

[EDIT: answer for the deleted question has been moved to another topic]

[Updated on: Sat, 05 April 2008 03:45]

Report message to a moderator

Previous Topic:	Sending email from a form
Next Topic:	update

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 27 10:31:01 CDT 2024