Need Duplicate Updatable column on 2 canvases [message #580840] |
Thu, 28 March 2013 09:32 ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
whatfur
Messages: 29 Registered: July 2006
|
Junior Member |
|
|
I have a form which utilizes 2 canvases that the user can toggle between. There is a database column that I would like to have appear on both and be updatable from either place. In my search here first, I found where I could set up a non-database item and copy to it at the point of Post-Query...and that comes close, but I need both columns to not just reflect the db column but be able to update it. I am about to try using a second trigger to move things from a non-DB column to a DB-column next, but just wondered if there is a better way. When I first compiled with the designer the duplicate column I set up as a DB column also. It only gave me warnings (that I could have lived with) but the ultimate compile my system does outside of the designer calls it an error.
Any help appreciated.
|
|
|
Re: Need Duplicate Updatable column on 2 canvases [message #580841 is a reply to message #580840] |
Thu, 28 March 2013 09:46 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
cookiemonster
Messages: 13937 Registered: September 2008 Location: Rainy Manchester
|
Senior Member |
|
|
Redesign your screen layout so that the item appears on one canvas and the other canvase doesn't overlap it.
Or stick with having a non-database item for one, populate it post-query and have it's when-validate-item trigger modify the db item.
|
|
|
|
Re: Need Duplicate Updatable column on 2 canvases [message #580844 is a reply to message #580843] |
Thu, 28 March 2013 10:18 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
whatfur
Messages: 29 Registered: July 2006
|
Junior Member |
|
|
One more question though...I have a "commit" button on my screen that when pressed usually commits the change without question. Since putting this change in I am getting the question asking me "Do you want to save the changes you have made?" My "Commit" button press should have been enough of an answer. What in the change is causing the "Do you want to save..." question?
[Updated on: Thu, 28 March 2013 10:20] Report message to a moderator
|
|
|
|
Re: Need Duplicate Updatable column on 2 canvases [message #580849 is a reply to message #580848] |
Thu, 28 March 2013 10:57 ![Go to previous message Go to previous message](/forum/theme/orafaq/images/up.png) ![Go to next message Go to next message](/forum/theme/orafaq/images/down.png) |
whatfur
Messages: 29 Registered: July 2006
|
Junior Member |
|
|
Thank you for the quick response. Actually because I placed my new assignment in the Post-Query trigger of the datablock below the
set_record_property (:system.trigger_record, 'my.block', STATUS, QUERY_STATUS)
instead of above...it was doing the prompting even after the commit. (found this answer here also)
Thank you and I send you a virtual Ginger Snap.
This can be marked as closed.
|
|
|
|
|