Hi To All
when the report runs i just want some filed to be save the data in my another temp table is there is any process
ttsBegin;
while select DimensionstatmentTmp where DimensionstatmentTmp.MainAccount == ledgerTransStatementStagingTmp.MainAccount
{
DimensionstatmentTmp.AccumulatedMST= ledgerTransStatementStagingTmp.AccumulatedMST;
DimensionstatmentTmp.AmountCredit = ledgerTransStatementStagingTmp.AmountCredit;
Dimensionstatmenttmp.AmountDebit = ledgerTransStatementStagingTmp.AmountDebit;
DimensionstatmentTmp.MainAccount = ledgerTransStatementStagingTmp.MainAccount;
DimensionstatmentTmp.insert();
}
ttsCommit;
}
want to insert the data in " DimensionstatmentTmp"
*This post is locked for comments
I have the same question (0)