| Commit in a Canvas [message #378977] |
Sat, 03 January 2009 06:50  |
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 #379992 is a reply to message #378982] |
Thu, 08 January 2009 17:56  |
 |
djmartin
Messages: 10181
Registered: March 2005
Location: Surges Bay TAS 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
|
|
|
|
] 
Blog
Search
Help
Members
Register
Login
Home
