Home » Developer & Programmer » Forms » Commit in a Canvas
Commit in a Canvas [message #378977] Sat, 03 January 2009 06:50 Go to next message
Messages: 36
Registered: October 2006
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
Messages: 21146
Registered: June 2005
Location: Croatia, Europe
Senior Member
Account Moderator
Why FORMS_DDL('commit')? I'd rather try with

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
Messages: 10180
Registered: March 2005
Location: Surges Bay TAS Australia
Senior Member
Account Moderator

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

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

Current Time: Thu Aug 17 16:31:03 CDT 2017

Total time taken to generate the page: 0.15943 seconds