Home » Developer & Programmer » Forms » Commit in a Canvas
Commit in a Canvas [message #378977] Sat, 03 January 2009 06:50 Go to next message
h_jitendras
Messages: 36
Registered: October 2006
Member
Hi,
I have a form and on click of a button,i'm opening a canvas in which I'm displaying editable columns and I want to save those changes.For that in that canvas,i'm giving a "Ok" and a "Cancel" button.On the press of "Ok", I want to save those changes to the database.i'm using forms_ddl('commit') but the changes aren't getting saved even after using that statement.
When I try to exit the main form however,it asks me "do you want to save the changes" and when I say Yes, it then saves the changes.
I have set the property of the datablock(referred in the canvas) to updateable.

what else should i add or is that i'm overlooking something?
Also please clear my doubt whether in such a case by commiting in the canvas,i'm also saving any changes done at the form level or is it something like the concept of an autonomous transaction?

Thanks for your time for reading thru this..
Re: Commit in a Canvas [message #378982 is a reply to message #378977] Sat, 03 January 2009 08:16 Go to previous messageGo to next message
Littlefoot
Messages: 20900
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Why FORMS_DDL('commit')? I'd rather try with
standard.commit;


COMMIT in a form will commit changes in the whole form, not only those made on the current canvas' block.
Re: Commit in a Canvas [message #379992 is a reply to message #378982] Thu, 08 January 2009 17:56 Go to previous message
djmartin
Messages: 10180
Registered: March 2005
Location: Canberra ACT Australia
Senior Member
Account Moderator
LF,

In this situation, as the changes appear to be being done in regular Forms' items, wouldn't the regular 'commit' and 'commit_form' work?

David
Previous Topic: Close Form Automatically after 3 Min
Next Topic: Oracle forms
Goto Forum:
  


Current Time: Wed Dec 07 18:36:30 CST 2016

Total time taken to generate the page: 0.36399 seconds