Home » Developer & Programmer » Forms » how to execute and update
how to execute and update [message #262592] Mon, 27 August 2007 13:18 Go to next message
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
Re: how to execute and update [message #262613 is a reply to message #262592] Mon, 27 August 2007 21:21 Go to previous messageGo to next message
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
Re: how to execute and update [message #262644 is a reply to message #262592] Tue, 28 August 2007 00:10 Go to previous messageGo to next message
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.
Re: how to execute and update [message #262731 is a reply to message #262613] Tue, 28 August 2007 03:01 Go to previous messageGo to next message
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
Re: how to execute and update [message #263037 is a reply to message #262731] Tue, 28 August 2007 20:33 Go to previous messageGo to next message
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
Re: how to execute and update [message #263323 is a reply to message #263037] Wed, 29 August 2007 13:13 Go to previous message
rajat_chaudhary
Messages: 141
Registered: November 2006
Location: india
Senior Member

no not all....

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

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


Current Time: Sun Feb 09 09:50:44 CST 2025