Re: [Axapta-Knowledge-Village] Updating records in a table
Thank Arijit. It works. Chirani. - Original Message From: Arijit Basu [EMAIL PROTECTED] To: Axapta-Knowledge-Village@yahoogroups.com Sent: Wednesday, October 31, 2007 5:36:35 PM Subject: Re: [Axapta-Knowledge-Village] Updating records in a table Hi, Use the update statement inside a ttsbegin ttscommit loop. Cheers Arijit On 10/31/07, ras_here2002 [EMAIL PROTECTED] wrote: Some times i experience, when I try to update records in a table by a job, DAX not allowing me to do so. I am getting an error `Cannot Edit the record Update must be performed inside a transaction' Can you tell me why I am getting this? Chirani. -- Arijit Basu [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Come and choose your preferred name for Microsoft Dynamics AX on the Axapta Knowledge Village, Visit www.axapta-knowledge-village.tk Yahoo! Groups Links __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Come and choose your preferred name for Microsoft Dynamics AX on the Axapta Knowledge Village, Visit www.axapta-knowledge-village.tk Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/join (Yahoo! ID required) * To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
Re: [Axapta-Knowledge-Village] Updating records in a table
Hi, Try to write a job like this ttsbegin; select forupdate TableName .. TableName.update(); ttscommit; Regards, Venkat ras_here2002 [EMAIL PROTECTED] wrote: Some times i experience, when I try to update records in a table by a job, DAX not allowing me to do so. I am getting an error `Cannot Edit the record Update must be performed inside a transaction' Can you tell me why I am getting this? Chirani. __ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com [Non-text portions of this message have been removed]
Re: [Axapta-Knowledge-Village] Updating records in a table
Hi, Use the update statement inside a ttsbegin ttscommit loop. Cheers Arijit On 10/31/07, ras_here2002 [EMAIL PROTECTED] wrote: Some times i experience, when I try to update records in a table by a job, DAX not allowing me to do so. I am getting an error `Cannot Edit the record Update must be performed inside a transaction' Can you tell me why I am getting this? Chirani. -- Arijit Basu [Non-text portions of this message have been removed] Sharing the knowledge on Axapta. Visit www.frappr.com/axapta for axapta friends. Come and choose your preferred name for Microsoft Dynamics AX on the Axapta Knowledge Village, Visit www.axapta-knowledge-village.tk Yahoo! Groups Links * To visit your group on the web, go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/ * Your email settings: Individual Email | Traditional * To change settings online go to: http://groups.yahoo.com/group/Axapta-Knowledge-Village/join (Yahoo! ID required) * To change settings via email: mailto:[EMAIL PROTECTED] mailto:[EMAIL PROTECTED] * To unsubscribe from this group, send an email to: [EMAIL PROTECTED] * Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/