insert_recordset 临时表

在lookup或者类中，用insert_recordset方法向临时表插入数据后，需要用select tmpTable来初始化临时表的buffer，数据才可以正常呈现。

如：

public static void lookupRate(FormStringControl         _contrl,
                              TNK_ToRisk_C              _custAccount,
                              TNK_LTSeiZhaCh_COCTR_C    _costCenter,
                              TNK_SB_C                  _itemId)
{
    SysTableLookup              sysTableLookup;
    Query                       q;
    QueryBuildDataSource        qbds;
    TNK_BaseRate_C              baseRate_C;
    TNK_RDB_JIGSOBA_UNT_SBT     unt_SBT;
    TNK_TmpCustomerRate         tmpCustomerRate;

    delete_from tmpCustomerRate;
    ttsBegin;
    insert_recordset tmpCustomerRate
        (JIGSOBA_UNT_SBT, SCBaseRate_C, LTSeiZhaCh_COCTR_C, ToRisk_C, SB_C)
    select BaseRate_C, SCBaseRate_C, LTSeiZhaCh_COCTR_C, ToRisk_C, _itemId from baseRate_C
        where baseRate_C.ToRisk_C == _custAccount
           && baseRate_C.LTSeiZhaCh_COCTR_C == _costCenter
           && baseRate_C.SCBaseRate_C // 特殊汇率
           && baseRate_C.SYOUNINN_F // 已批准
    exists join unt_SBT
        where unt_SBT.JIGSOBA_UNT_SBT == baseRate_C.BaseRate_C
           && unt_SBT.SB_C == _itemId;

    if(!tmpCustomerRate)
    {
        insert_recordset tmpCustomerRate
            (JIGSOBA_UNT_SBT, SCBaseRate_C, LTSeiZhaCh_COCTR_C, ToRisk_C, SB_C)
        select BaseRate_C, SCBaseRate_C, LTSeiZhaCh_COCTR_C, ToRisk_C, _itemId from baseRate_C
            where baseRate_C.ToRisk_C == _custAccount
               && baseRate_C.LTSeiZhaCh_COCTR_C == _costCenter
               && !baseRate_C.SCBaseRate_C // 非特殊汇率
        exists join unt_SBT
            where unt_SBT.JIGSOBA_UNT_SBT == baseRate_C.BaseRate_C
               && unt_SBT.SB_C == _itemId;

    }
    ttsCommit;
    
    select tmpCustomerRate;
   
    q                           = new Query();
    qbds                        = q.addDataSource(tableNum(TNK_TmpCustomerRate));
    sysTableLookup              = SysTableLookup::newParameters(tableNum(TNK_TmpCustomerRate), _contrl);

    sysTableLookup.addLookupfield(fieldNum(TNK_TmpCustomerRate, JIGSOBA_UNT_SBT));
    sysTableLookup.addLookupfield(fieldNum(TNK_TmpCustomerRate, SCBaseRate_C));
    sysTableLookup.addLookupfield(fieldNum(TNK_TmpCustomerRate, ToRisk_C));
    sysTableLookup.addLookupfield(fieldNum(TNK_TmpCustomerRate, LTSeiZhaCh_COCTR_C));
    sysTableLookup.addLookupfield(fieldNum(TNK_TmpCustomerRate, SB_C));

    sysTableLookup.parmQuery(q);
    sysTableLookup.parmTmpBuffer(tmpCustomerRate);
    sysTableLookup.performFormLookup();
}