Re: [Axapta-Knowledge-Village] delete_from vs loop delete

2010-09-02 Thread Zainal Arifin
t; axapta-knowledge-vill...@yahoogroups.com] *On Behalf Of *thomas 'znal' > ramdhan > *Sent:* Wednesday, September 01, 2010 6:21 PM > > *To:* Axapta-Knowledge-Village@yahoogroups.com > *Subject:* Re: [Axapta-Knowledge-Village] delete_from vs loop delete > > > >

RE: [Axapta-Knowledge-Village] delete_from vs loop delete

2010-09-02 Thread Harry Deshpande
com] On Behalf Of thomas 'znal' ramdhan Sent: Wednesday, September 01, 2010 6:21 PM To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] delete_from vs loop delete Hi Deshpande, This is my code, I insert below code in Tables/ReqTrans/insertFromreqPO

Re: [Axapta-Knowledge-Village] delete_from vs loop delete

2010-09-01 Thread thomas 'znal' ramdhan
gards > > > > harry > > > > *From:* Axapta-Knowledge-Village@yahoogroups.com [mailto: > axapta-knowledge-vill...@yahoogroups.com] *On Behalf Of *thomas 'znal' > ramdhan > *Sent:* Wednesday, September 01, 2010 7:43 AM > > *To:* Axapta-Knowledge-Vill

RE: [Axapta-Knowledge-Village] delete_from vs loop delete

2010-09-01 Thread Harry Deshpande
groups.com Subject: Re: [Axapta-Knowledge-Village] delete_from vs loop delete Hi Harry, I didn't delete reqTrans records. It's my own customized table, but the process is inside the master planning scheduler. On Wed, Sep 1, 2010 at 9:31 PM, Harry Deshpande mailto:har...@microsoft.co

Re: [Axapta-Knowledge-Village] delete_from vs loop delete

2010-09-01 Thread thomas 'znal' ramdhan
you are facing (other than lock error while deleting)? > > Regards > > harry > > > > *From:* Axapta-Knowledge-Village@yahoogroups.com [mailto: > axapta-knowledge-vill...@yahoogroups.com] *On Behalf Of *thomas 'znal' > ramdhan > *Sent:* 01 September 2010 10:34 >

RE: [Axapta-Knowledge-Village] delete_from vs loop delete

2010-09-01 Thread Harry Deshpande
mber 2010 10:34 To: Axapta-Knowledge-Village@yahoogroups.com<mailto:Axapta-Knowledge-Village@yahoogroups.com> Subject: Re: [Axapta-Knowledge-Village] delete_from vs loop delete Hi Burtt, Thanks for brief explanation :) I have declare all suitable index for my table, but sometimes stil

Re: [Axapta-Knowledge-Village] delete_from vs loop delete

2010-09-01 Thread thomas 'znal' ramdhan
dge-Village@yahoogroups.com [mailto: > axapta-knowledge-vill...@yahoogroups.com] *On Behalf Of *thomas 'znal' > ramdhan > *Sent:* 01 September 2010 10:34 > > *To:* Axapta-Knowledge-Village@yahoogroups.com > *Subject:* Re: [Axapta-Knowledge-Village] delete_from vs loop delete > > &g

Re: [Axapta-Knowledge-Village] delete_from vs loop delete

2010-09-01 Thread thomas 'znal' ramdhan
uuh, I forgot to use that, I'll try it Salonen. Thanks for replying :) On Wed, Sep 1, 2010 at 5:03 PM, Marko Salonen wrote: > > > try-catch deadlock and retry? > > > On 1 September 2010 10:33, thomas 'znal' ramdhan > wrote: > >> >> >> Hi Burtt, >> >> Thanks for brief explanation :) >> I have de

RE: [Axapta-Knowledge-Village] delete_from vs loop delete

2010-09-01 Thread Malcolm Burtt
@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of thomas 'znal' ramdhan Sent: 01 September 2010 10:34 To: Axapta-Knowledge-Village@yahoogroups.com Subject: Re: [Axapta-Knowledge-Village] delete_from vs loop delete Hi Burtt, Thanks for brief explanation :) I have d

Re: [Axapta-Knowledge-Village] delete_from vs loop delete

2010-09-01 Thread Marko Salonen
try-catch deadlock and retry? On 1 September 2010 10:33, thomas 'znal' ramdhan wrote: > > > Hi Burtt, > > Thanks for brief explanation :) > I have declare all suitable index for my table, but sometimes still returns > me lock error. If I use batch helpers, for sure I get more lock issue in > acti

Re: [Axapta-Knowledge-Village] delete_from vs loop delete

2010-09-01 Thread thomas 'znal' ramdhan
-Village@yahoogroups.com [mailto: > axapta-knowledge-vill...@yahoogroups.com] *On Behalf Of *thomas 'znal' > ramdhan > *Sent:* 01 September 2010 06:20 > *To:* Axapta-Knowledge-Village@yahoogroups.com > *Subject:* [Axapta-Knowledge-Village] delete_from vs loop delete > > > > &

RE: [Axapta-Knowledge-Village] delete_from vs loop delete

2010-09-01 Thread Malcolm Burtt
ge-Village@yahoogroups.com [mailto:axapta-knowledge-vill...@yahoogroups.com] On Behalf Of thomas 'znal' ramdhan Sent: 01 September 2010 06:20 To: Axapta-Knowledge-Village@yahoogroups.com Subject: [Axapta-Knowledge-Village] delete_from vs loop delete Dear all, I'd like to as

[Axapta-Knowledge-Village] delete_from vs loop delete

2010-08-31 Thread thomas 'znal' ramdhan
Dear all, I'd like to ask about delete issue in AX. AX has 2 way to delete records by using *'delete_from'* or below code *while select forUpdate * from tableA { tableA.doDelete(); } *Which one do you prefer to delete some records from both above code ? Sometimes, I found locked table if I