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));
}