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/
