Insert_Recordset 用法举例



static void CopyItemInfo(Args _args)
{
    InventTable inventTable;
    InventSum inventSum;
    InsertInventTableInventSum insertInventTableInventSum;
    // insert_recordset uses only one round-trip for the copy operation.
    // A record-based insert would need one round-trip per record in InventSum.
    ttsBegin;
    insert_recordset insertInventTableInventSum (ItemId,AltItemId,PhysicalValue,PostedValue)
            select ItemId,AltItemid from inventTable where inventTable.ItemId == '1001'
                join PhysicalValue,PostedValue from inventSum
                       where inventSum.ItemId == inventTable.ItemId;
    ttsCommit;
    elect count(RecId) from insertInventTableInventSum;
    info(int642str(insertInventTableInventSum.RecId));
    // Additional code to use the copied data.
}

static void CopyItemInfoskipDataMethod(Args _args)
{
    InventTable inventTable;
    InventSum inventSum;
    InsertInventTableInventSum insertInventTableInventSum;
    ttsBegin;
    // Skip override check on insert.
    insertInventTableInventSum.skipDataMethods(true);
    insert_recordset insertInventTableInventSum (ItemId,AltItemId,PhysicalValue,PostedValue)
    select ItemId,Altitemid from inventTable where inventTable.ItemId == '1001'
    join PhysicalValue,PostedValue from inventSum
         where inventSum.ItemId == inventTable.ItemId;
     ttsCommit;
    select count(RecId) from insertInventTableInventSum;   

     info(int642str(insertInventTableInventSum.RecId));   
}