Hi Jaya; Long time no email :-)
Remember the logging form for worklog history loss we did? >From Form 1 push the worklog value into Form 2 (yes it only gets the TR portion) In Form 2 do a set fields and take "Worklog + Worklog" This will concatenate the DB.worklog from the query and the still pending TR.worklog from the transaction buffer. I avoid the Commits as much as possible as it really goofs up the 'rollback' should a latter submit / update fail. HTH Thanks-n-advance; HDT Platform Incident / Problem Manager & Architect Robert Molenda IT OS PA Tel: +1 408 503 2701 Fax: +1 408 503 2912 Mobile: +1 408 472 8097 [EMAIL PROTECTED] Quality begins with your actions. ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of [EMAIL PROTECTED] Sent: Friday, March 16, 2007 5:10 AM To: [email protected] Subject: Re: Diary Field Issue Jaya, If the solution works for you bar the missing TR value, then force a commit down to the database on form 1 before you do the set fields in form 2. You can do this with an Application-Release-Pending command run before the push fields (Phase 2) operation. Alternatively do the submit to form 2 with an active link firing after modify. Or if the entry in form 2 already exists then get an after modify active link to "touch" the record to cause the set fields action to fire. Brian Bishop ________________________________ From: Action Request System discussion list(ARSList) [mailto:[EMAIL PROTECTED] On Behalf Of Joe DeSouza Sent: 16 March 2007 11:46 To: [email protected] Subject: Re: Diary Field Issue Hmm .. in that case I wonder if a direct SQL to update the diary field contents would yield better results? Want to give that a shot? Joe ----- Original Message ---- From: jaya munjal <[EMAIL PROTECTED]> To: [email protected] Sent: Friday, March 16, 2007 3:14:38 AM Subject: Re: Diary Field Issue ** Hi Joe Thanks for your suggestion. I tried this, but the set field only gets the DB Value and not the TR.Value of the dairy field, as the data is still not updated in the database. Secondly the issue comes with the value of Time stamp. Please let me know if you have any other work around. Many Thanks for your help Regards Jaya Joe DeSouza <[EMAIL PROTECTED]> wrote: Jaya, Approach your problem from a slightly different angle... Instead of doing a Push Field from the main form to form 2 which is working as designed by copying only the TR value of the Diary field, do a Set Field filter on form 2, on 'Submit'. Set fields will copy the whole shebang TR + DB value... Hope this helps. Joe D'Souza ----- Original Message ---- From: jaya munjal <[EMAIL PROTECTED]> To: [email protected] Sent: Thursday, March 15, 2007 2:26:36 AM Subject: Diary Field Issue ** Hi Listerner I am facing a problem while working with Diary Fields. Below is the scenario that I want to implement When ever the status is set to Closed on Form 1, it pushes the data to Form 2. There is a work log field( Diary Field) that also needs to be pushed to Form 2( Dairy Field). Issue As per design only current TR.Value of Diary field is being pushed. I require the complete worklog to be pushed. Any suggestions or workaround would highly be appreciated. Thanks Jaya ________________________________ Need Mail bonding? Go to the Yahoo! Mail Q&A <http://answers.yahoo.com/dir/index;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTE wOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=ask&s id=396546091> for great tips from Yahoo! Answers <http://answers.yahoo.com/dir/index;_ylc=X3oDMTFvbGNhMGE3BF9TAzM5NjU0NTE wOARfcwMzOTY1NDUxMDMEc2VjA21haWxfdGFnbGluZQRzbGsDbWFpbF90YWcx?link=ask&s id=396546091> users. __20060125_______________________This posting was submitted with HTML in it___ __20060125_______________________This posting was submitted with HTML in it___ _______________________________________________________________________________ UNSUBSCRIBE or access ARSlist Archives at www.arslist.org ARSlist:"Where the Answers Are"
