Join Source
info("Begin:"+queryvalue(timenow()));
ttsbegin;
while select _invTrans
join _invTable
where _invTrans.JournalId == _invTable.JournalId &&
_invTable.BSEFinishKind == BSEFinishKind::Normal &&
_invTable.JournalNameId == SalesParameters::find().JournalNameId
join _saTBL
where _invTable.SalesId == _saTBL.SalesId
{
iNum ++;
}
ttscommit;
/*
ttsbegin;
while select _invTable
where _invTable.BSEFinishKind == BSEFinishKind::Normal &&
_invTable.JournalNameId == SalesParameters::find().JournalNameId
{
while select _invTrans
where _invTrans.JournalId == _invTable.JournalId
{
//select _saTBL
//where _saTBL.SalesId == _invTable.SalesId;
iNum ++;
}
}
ttscommit;
*/
info(int2str(iNum));
info("End:"+queryvalue(timenow()));
消息 (15:48:27) | |||||||||
Begin:56849 | 56849 | ||||||||
End:56907 | 56907 | ||||||||
58 | |||||||||
消息 (15:48:27) | |||||||||
Begin:57318 | 57318 | ||||||||
End:57445 | 57445 | ||||||||
127 |
posted on 2008-08-13 16:16 lingdanglfw 阅读(226) 评论(0) 编辑 收藏 举报