OraFAQ Forum: Forms » how to execute and update

Home » Developer & Programmer » Forms » how to execute and update

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

how to execute and update [message #262592]

Mon, 27 August 2007 13:18

rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india

Senior Member

hi gurus,

actually my problem is in a module in FORMS 6i , so please help me to come out of this problem.....

i have 5 (database modules) in a form having "relationship" against a column.

now i want that when i enter any value in that particular text box then all the data should come automatically ( this is achieved but)
and when i click the save button then the changes should be saved in the database..........

regards
rajat

Report message to a moderator

Re: how to execute and update [message #262613 is a reply to message #262592]

Mon, 27 August 2007 21:21

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

Senior Member
Account Moderator

What changes? You have described a form containing a master block and five detail blocks but you haven't mentioned what data you have changed. Are you getting a message when you exit the form?

David

Report message to a moderator

Re: how to execute and update [message #262644 is a reply to message #262592]

Tue, 28 August 2007 00:10

musman
Messages: 147
Registered: July 2007
Location: Lahore

Senior Member

	if:system.form_status='CHANGED' then
		commit_form;

i think this will work on save if some change found then it will be saved else not.

Report message to a moderator

Re: how to execute and update [message #262731 is a reply to message #262613]

Tue, 28 August 2007 03:01

rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india

Senior Member

my exact question is that :-

form contains:-

1. master block
2. 5 detail blocks ( 1 block having property to show 10 records)
now the functionality of forms for execute data is

Quote:

First to press F7 for enter_query mode
and
press F8 to execute data for that entered value from all 5 detail blocks..

Now my requirement is when
after enter any value in the text box of master-block,
i press "ENTER"

( the block status should become "query" only then form builder will update that appeared data.)

The data should appear in their respective fields.

and then if i make any changes then i press save button it should be saved in the datbase(either a single value in the block showing 10 records).

all this functionality should be done only at "enter".

regards
rajat

Report message to a moderator

Re: how to execute and update [message #263037 is a reply to message #262731]

Tue, 28 August 2007 20:33

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

Senior Member
Account Moderator

Have you downloaded and run the sample master/detail form from the Oracle Forms website?

The behaviour you are seeking sounds fairly standard to me.

David

Report message to a moderator

Re: how to execute and update [message #263323 is a reply to message #263037]

Wed, 29 August 2007 13:13

rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india

Senior Member

no not all....

why you are feeling like that martin.......

rajat

Report message to a moderator

Previous Topic:	How can I display data in Excel Sheet
Next Topic:	Function Keys in forms

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Aug 31 12:12:26 CDT 2025