Home » Developer & Programmer » Forms » Save option in Datablocks ! (Oracle IDS 10g,Windows XP)
Save option in Datablocks ! [message #378220] Mon, 29 December 2008 06:07 Go to next message
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
Re: Save option in Datablocks ! [message #378229 is a reply to message #378220] Mon, 29 December 2008 06:34 Go to previous messageGo to next message
Littlefoot
Messages: 20895
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.
Re: Save option in Datablocks ! [message #378266 is a reply to message #378229] Mon, 29 December 2008 11:05 Go to previous messageGo to next message
mandeepmandy
Messages: 79
Registered: May 2008
Location: USA
Member

I guess he created three diffrent canvas based upon one data block.Am i right?
Re: Save option in Datablocks ! [message #378312 is a reply to message #378266] Mon, 29 December 2008 21:46 Go to previous messageGo to next message
varosh81
Messages: 178
Registered: February 2008
Location: CHENNAI
Senior Member
yes ! you are right ! 3 forms are in 3 different Canvases !
Re: Save option in Datablocks ! [message #378322 is a reply to message #378312] Tue, 30 December 2008 00:23 Go to previous messageGo to next message
Littlefoot
Messages: 20895
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")?
Re: Save option in Datablocks ! [message #378391 is a reply to message #378322] Tue, 30 December 2008 04:12 Go to previous messageGo to next message
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
Re: Save option in Datablocks ! [message #378398 is a reply to message #378391] Tue, 30 December 2008 04:41 Go to previous messageGo to next message
Littlefoot
Messages: 20895
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?
Re: Save option in Datablocks ! [message #378401 is a reply to message #378398] Tue, 30 December 2008 05:07 Go to previous messageGo to next message
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
Re: Save option in Datablocks ! [message #379793 is a reply to message #378401] Thu, 08 January 2009 00:13 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT 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
Previous Topic: Call ASP.NET web page silently in Oracle Form
Next Topic: urgent Client_host issue
Goto Forum:
  


Current Time: Tue Dec 06 00:10:39 CST 2016

Total time taken to generate the page: 0.08970 seconds