Hi Compashi,
Pls, try to search for the keyword 'skipDataMethods' in the
Developers Guide. There's some explanation of the "performance-hurting
things" of the recordSet operations.
I hope this will help,
Victor
--- In Axapta-Knowledge-Village@yahoogroups.com, "compashi"
<[EMAIL PROTECTED]> wrote:
>
> Hi Victor,
>
> I don't understand why do you mean by saying that
> skipDataMethods() please elaborate the same and also mine point is
> again that if we can use Insert_Recordset() in conjuction with
> while select it will be more productive in a various situations.
>
> looking for your further suggetions and also i want to use the
above
> method with some of my temporary table so pleas confirm whether it
> can be used with the same.
>
>
> Byeeeeeeeeeeeeeeee
>
>
>
> --- In Axapta-Knowledge-Village@yahoogroups.com, "victor_zuev"
> <[EMAIL PROTECTED]> wrote:
> >
> > I think, insert_Recordset works with non-temporary tables.
> > If your non-temporary table has a overridden insert method, use
> > skipDataMethods() otherwise it is a record-by-record operation
like
> > 'while select'
> >
> > I hope this will help,
> > Victor
> >
> >
> > --- In Axapta-Knowledge-Village@yahoogroups.com, "compashi"
> > <[EMAIL PROTECTED]> wrote:
> > >
> > > hello everybody,
> > >
> > > is the above code is possible in Axapta. If not then why and if
> yes
> > > then if there is any error then correct it.
> > >
> > > As you know guys that insert_Recordset is a performance booster
> > then
> > > i thought if it could be used with while select then it will be
a
> > > great one but i am not sure whether it will work or not check
it
> > out.
> > > Or if there is any alternative then please let me know how that
> is
> > > possible.
> > >
> > > Have a look:
> > >
> > > CustTrans custTrans;
> > > ;
> > > ttsbegin;
> > > delete_from TmpTable;
> > >
> > > if(varDrNo)
> > > {
> > > insert_recordset TmpTable(tmpSreDrno,tmpAccnum,tmpVoucher,
tmpDate,
> > >
> tmpTxt,tmpAmount,tmpTransType,tmpInvoice,tmpReceiptType,tmpChequeNo,
> > > tmpReverse,tmpChequeDate,tmpChequeBank,tmpNarration,tmpPaymMode,
> > > tmpPostingProfile,tmpRecID)
> > > while select sreDrno,AccountNum,Voucher,TransDate,Txt,
> > > AmountCur,TransType,Invoice,sreReceiptType,sreChequeNo,
> > > sreReverse,sreChequeDate,sreChequeBank,sreNarration,PaymMode,
> > > PostingProfile,RecId from custtrans where custtrans.
> > sreDRNo==varDrNo
> > > && custtrans.TransDate>=Fromdate && custTrans.
TransDate<=ToDate
> > > {
> > > ;
> > > }
> > > }
> > > ttscommit;
> > >
> > >
> > > Please suggest me your views .
> > >
> > > Byeeeeeeeeeeee to everybody.
------------------------ Yahoo! Groups Sponsor --------------------~-->
In low income neighborhoods, 84% do not own computers.
At Network for Good, help bridge the Digital Divide!
http://us.click.yahoo.com/EpW3eD/3MnJAA/cosFAA/kGEolB/TM
--------------------------------------------------------------------~->
Sharing the knowledge on Axapta.
Yahoo! Groups Links
<*> To visit your group on the web, go to:
http://groups.yahoo.com/group/Axapta-Knowledge-Village/
<*> 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/
