OraFAQ Forum: Forms » Question about filling a TEXT

Home » Developer & Programmer » Forms » Question about filling a TEXT_ITEM (Forms 10g)

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

Question about filling a TEXT_ITEM [message #461730]

Mon, 21 June 2010 03:52

mrwhiteonee
Messages: 2
Registered: June 2010
Location: Romania

Junior Member

Hello ,

I`m new with Oracle Forms , so please don`t mind if this is a stupid question .

I have the following trigger WHEN-BUTTON-PRESSED :

DECLARE
BEGIN
IF :SEARCH.SBOX is not null then -- (search text item)
IF :SEARCH.LIST45 = 'ERPLINK' THEN --(a drop down list)
GO_ITEM('CUSTOMERVIEW.ERPLINK');
enter_query;
IF :System.Mode = 'ENTER-QUERY' THEN
:CUSTOMERVIEW.ERPLINK:=:SEARCH.SBOX;
Synchronize;
execute_query;
END IF;
END IF;
END IF;
END;

What do I want is the following thing :

I have a text box :SEARCH.SBOX in which I write a number.
When I press the button which will execute that trigger above, I want that the value from :SEARCH.SBOX, after the form will go to enter-query mode to fill up another text_item :CUSTOMERVIEW.ERPLINK with same value and execute_query(this text item is in master-detail form).

The thing is that is not working...

So please help me.

Thank you.

Report message to a moderator

Re: Question about filling a TEXT_ITEM [message #461739 is a reply to message #461730]

Mon, 21 June 2010 04:22

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

You need to set the onetime_where property - have a look in form builder help for details.

Report message to a moderator

Re: Question about filling a TEXT_ITEM [message #462205 is a reply to message #461730]

Wed, 23 June 2010 03:21

mrwhiteonee
Messages: 2
Registered: June 2010
Location: Romania

Junior Member

Hello,

Ok , for others to know the solution was to add this line :

Set_Block_Property('CUSTOMERVIEW',DEFAULT_WHERE,'ERPLINK ='|| :SEARCH.SBOX);

Thanks.

Report message to a moderator

Re: Question about filling a TEXT_ITEM [message #462214 is a reply to message #462205]

Wed, 23 June 2010 03:53

cookiemonster
Messages: 13938
Registered: September 2008
Location: Rainy Manchester

Senior Member

Thanks for letting us know.
I would have thought you'd want to remove a few lines as well though: enter_query and syncronize serve no purpose for starters.

Report message to a moderator

Previous Topic:	search
Next Topic:	How to invoke dll from Oracle Forms 10g

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 09:38:13 CDT 2024