Home » Developer & Programmer » Forms » Need Duplicate Updatable column on 2 canvases (Forms 6.0/Unix)
Need Duplicate Updatable column on 2 canvases [message #580840] Thu, 28 March 2013 09:32 Go to next message
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 messageGo to next message
cookiemonster
Messages: 11285
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 #580843 is a reply to message #580841] Thu, 28 March 2013 10:11 Go to previous messageGo to next message
whatfur
Messages: 29
Registered: July 2006
Junior Member
Redesign was not doable, but your suggestion works "form"e. Thank you
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 messageGo to next message
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 #580848 is a reply to message #580844] Thu, 28 March 2013 10:48 Go to previous messageGo to next message
cookiemonster
Messages: 11285
Registered: September 2008
Location: Rainy Manchester
Senior Member
You get that question when there are unsaved changes. Why that's happened depends on what you've done.
So give us more details of exactly what you have done.
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 messageGo to next message
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.
Re: Need Duplicate Updatable column on 2 canvases [message #580850 is a reply to message #580849] Thu, 28 March 2013 11:07 Go to previous messageGo to next message
cookiemonster
Messages: 11285
Registered: September 2008
Location: Rainy Manchester
Senior Member
Don't do it that way. Use:
set_item_property(<item that got changed post query>, item_is_valid, property_true);
Re: Need Duplicate Updatable column on 2 canvases [message #580858 is a reply to message #580850] Thu, 28 March 2013 13:20 Go to previous message
whatfur
Messages: 29
Registered: July 2006
Junior Member
Even better. Thanks
Previous Topic: Display Query
Next Topic: Display Department name in emp table , along with employees details [merged 2 by jd]
Goto Forum:
  


Current Time: Sun Dec 21 13:03:28 CST 2014

Total time taken to generate the page: 0.08821 seconds