OraFAQ Forum: Forms » Links in forms

Home » Developer & Programmer » Forms » Links in forms

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

Links in forms [message #150118]

Tue, 06 December 2005 06:55

sharma.radha
Messages: 59
Registered: August 2005
Location: mumbai

Member

Hi to all..
Can some one suggests me how to create links on oracle forms 6i if it is possible which work like buttons,which run reports or call another form either by taking parameters or call reports and forms without any parameters.

Waiting for reply.

Radha.

Report message to a moderator

Re: Links in forms [message #150267 is a reply to message #150118]

Tue, 06 December 2005 23:31

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

What's wrong with creating a very wide button and putting the link text on it and then when the user presses it, voila, the button runs?

If you want to, you could try using the when-mouse-click or when-mouse-double-click triggers on a standard text field.

David

Upd: Fix typos.

[Updated on: Wed, 07 December 2005 19:21]

Report message to a moderator

Re [message #150358 is a reply to message #150267]

Wed, 07 December 2005 09:12

Shaila.Mehra
Messages: 88
Registered: July 2005
Location: mumbai

Member

No Message Body

[Updated on: Wed, 07 December 2005 09:13]

Report message to a moderator

Re: Links in forms [message #150359 is a reply to message #150267]

Wed, 07 December 2005 09:14

sharma.radha
Messages: 59
Registered: August 2005
Location: mumbai

Member

What is the 'link text' and how do we write triggers on text fields.

Radha.

Report message to a moderator

Re: Links in forms [message #150436 is a reply to message #150359]

Wed, 07 December 2005 19:34

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

'Link text' are the words that you can put on a button using the Set_Item_Property command Label option.

To put a trigger on an item open the Form Builder on the item in question, highlight the word 'triggers',press the green '+' sign on the left side menu, and select the trigger to be added.

David

Report message to a moderator

Re: Links in forms [message #150582 is a reply to message #150436]

Thu, 08 December 2005 09:32

sharma.radha
Messages: 59
Registered: August 2005
Location: mumbai

Member

David, i am not getting . Can you give me an example if you can.

Thanks
Sharma.

Report message to a moderator

Re: Links in forms [message #150666 is a reply to message #150582]

Fri, 09 December 2005 00:11

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Sorry. I can't be any more detailed than I have been. Please get the Form demonstration tutorial from the OTN website and work your way through it.

David

Report message to a moderator

Re: Links in forms [message #150754 is a reply to message #150666]

Fri, 09 December 2005 08:06

sharma.radha
Messages: 59
Registered: August 2005
Location: mumbai

Member

Well its ok.
Still you can give me the path from where i download the manuals from OTN.
I search there but i failed to found that.

Thanks.
Radha .

Report message to a moderator

Re: Links in forms [message #150907 is a reply to message #150754]

Sun, 11 December 2005 23:18

djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS Australia

Senior Member
Account Moderator

Go to the link as specified in the 'sticky' at the beginning of this forum http://www.oracle.com/technology/products/forms/index.html then select the Documentation Resource and either get something from that page or go to the 'Previous Releases' links. The manuals I use most often are Part Numbers A66593_02 and A50994_2

David

Report message to a moderator

Re: Links in forms [message #151063 is a reply to message #150118]

Mon, 12 December 2005 23:33

Scarlet.Zhu
Messages: 22
Registered: December 2005
Location: Shanghai

Junior Member

Hi,
Here is a program demonstrating the steps to submit a report via form.

:parameter.req_id :=
FND_REQUEST.SUBMIT_REQUEST (
:blockname.appsname,
:blockname.program,
:blockname.description,
:blockname.start_time,
:blockname.sub_req = ’Y’,
123, NAME_IN(’ORDERS.ORDER_ID’), ’abc’,
chr(0), ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’,
’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’, ’’);
IF arameter.req_id = 0 THEN
FND_MESSAGE.RETRIEVE;
FND_MESSAGE.ERROR;
ELSE
IF :SYSTEM.FORM_STATUS != ’CHANGED’ THEN
IF app_form.quietcommit THEN
/*form commits without asking user to save changes*/
fnd_message.set_name(’SQLGL’,
’GL_REQUEST_SUBMITTED’);
fnd_message.set_TOKEN(’REQUEST_ID’,
TO_CHAR(:PARAMETER.REQ_ID), FALSE);
fnd_message.show;
ELSE
fnd_message.set_name(’FND’,
db_trigger
Example 2
Example 3
Example 4
21 – 35 PL/SQL APIs for Concurrent Processing
’CONC–REQUEST SUBMISSION FAILED’);
fnd_message.error;
END IF;
ELSE
DO_KEY(’COMMIT_FORM’);
IF :SYSTEM.FORM_STATUS != ’CHANGED’ THEN
/*commit was successful*/
fnd_message.set_name(’SQLGL’,
’GL_REQUEST_SUBMITTED’);
fnd_message.set_TOKEN(’REQUEST_ID’,
TO_CHAR(:PARAMETER.REQ_ID), FALSE);
fnd_message.show;
END IF;
END IF;
END IF;

chr(0) means the end of listing parameters. No compiling errors will be shown but form runs with errors if chr(0) is not included.

[Updated on: Mon, 12 December 2005 23:34]

Report message to a moderator

Previous Topic:	autocreate
Next Topic:	Prevent Auto Change password screen

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Fri Sep 20 05:43:02 CDT 2024