OraFAQ Forum: Forms » Save option in Datablocks !

Home » Developer & Programmer » Forms » Save option in Datablocks ! (Oracle IDS 10g,Windows XP)

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

Save option in Datablocks ! [message #378220]

Mon, 29 December 2008 06:07

varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI

Senior Member

Hi All,

I have created 3 forms within the same datablock..

Now the prob is when i click commit button in third form, the previous two forms is also getting saved causing duplication which i dont want to occur ..

I just want the third form alone to get saved in its table ..

Is that possible to avoid this !

Thanks and Regards,
Varosh

Report message to a moderator

Re: Save option in Datablocks ! [message #378229 is a reply to message #378220]

Mon, 29 December 2008 06:34

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

Senior Member
Account Moderator

3 forms on the same datablock? How did you manage to do that, apart from the fact that every form is a separate product? How do you open each of them? Did you research use of CALL_FORM, OPEN_FORM and NEW_FORM built-ins?

Or, if this is not your situation, could you, please, put more effort in using correct terminology because - I don't understand what you are talking about.

Report message to a moderator

Re: Save option in Datablocks ! [message #378266 is a reply to message #378229]

Mon, 29 December 2008 11:05

mandeepmandy
Messages: 79
Registered: May 2008
Location: USA

Member

I guess he created three diffrent canvas based upon one data block.Am i right?

Report message to a moderator

Re: Save option in Datablocks ! [message #378312 is a reply to message #378266]

Mon, 29 December 2008 21:46

varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI

Senior Member

yes ! you are right ! 3 forms are in 3 different Canvases !

Report message to a moderator

Re: Save option in Datablocks ! [message #378322 is a reply to message #378312]

Tue, 30 December 2008 00:23

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

Senior Member
Account Moderator

Here you are again! What forms? Are you talking about datablocks whose layout style is "form" (as opposed to "tabular")?

Report message to a moderator

Re: Save option in Datablocks ! [message #378391 is a reply to message #378322]

Tue, 30 December 2008 04:12

varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI

Senior Member

Hi LittleFoot !

I have created a form with 3 different Canvas based on 3 different table..

I have linked these by using go_block ..

And the layout style for these is form and not tabular ..

In the 3rd Canvas i have kept Save button.. When it is clicked i want the field entries of the 3rd Canvas to be saved in its Corresponding table alone.. But the records of the previous canvases is also getting saved in its corresponding table again simultaneously which causes duplication !

Please help to overcome this !

Thanks and Regards,
Varosh

Report message to a moderator

Re: Save option in Datablocks ! [message #378398 is a reply to message #378391]

Tue, 30 December 2008 04:41

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

Senior Member
Account Moderator

I see; you'd like to make changes in any of three blocks within the same form, but save changes only in one block.

As far as I can tell, no way. COMMIT will save changes in the whole form.

Perhaps you should consider redesigning the form; why would you want to create three blocks based on the same table? Why not one block - one table relation?

Report message to a moderator

Re: Save option in Datablocks ! [message #378401 is a reply to message #378398]

Tue, 30 December 2008 05:07

varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI

Senior Member

Hi LittleFoot!

I have created 3 different canvas based on 3 different tables in a single datablock that is in a single form ..

I have done like this since the field entries of a form depends on the field entries of other form ..

Thanks and Regards,
varosh

Report message to a moderator

Re: Save option in Datablocks ! [message #379793 is a reply to message #378401]

Thu, 08 January 2009 00:13

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

Senior Member
Account Moderator

You CAN NOT save changes made in one part of an Oracle Form separately to the changes made in another part of the same Oracle Form.

I suggest you consider using a single block and spread the items across three canvases OR use a content canvas for the key part of the row and a stacked canvas, with a horizontal scrollbar, for the other parts of the row.

David

Report message to a moderator

Previous Topic:	Call ASP.NET web page silently in Oracle Form
Next Topic:	urgent Client_host issue

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Mon Feb 10 02:27:41 CST 2025