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