Hi
I think you
just need to drop the "while" from your select statement and that will do the
job for you. The insert_recordSet will still handle all the rows returned by the
select.
Regards
Malcolm Burtt
Global
IT Group
"Business Solutions designed for YOUR business
processes"
Global IT Group is the trading name of Touchstone Global Business
Solutions Ltd. and is part of the Touchstone Group
PLC.
-----Original Message-----
From: compashi [mailto:[EMAIL PROTECTED]
Sent: 24 February 2005 13:29
To: Axapta-Knowledge-Village@yahoogroups.com
Subject: [Axapta-Knowledge-Village] Hi Guys Is this a possible scenario to boost up performance
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.
Sharing the knowledge on Axapta.
Sharing the knowledge on Axapta.
Yahoo! Groups Sponsor
ADVERTISEMENT
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 the Yahoo! Terms of Service.