一次性打包插入数据库 RecordInsertList

时间:2022-09-20 20:15:21
static void recordInsertList(Args _args)
{
/*The RecordInsertList class allows to insert multiple records in to database.
new() - Creates a new object to hold records for insertion into the database.
add() - Adds a record to a RecordInsertList object for subsequent insertion into the database
insertDatabase() - Inserts all records, that have not already been inserted, in the current
RecordInsertList object.
The following example uses the RecordInsertList class to copy records from one table buffer to another.
*/
void copyBOM(BOMId _FromBOM, BOMId _ToBOM)
{
RecordInsertList BOMList;
BOM BOM, newBOM;
BOMList = new RecordInsertList(tableNum(BOM));
while select BOM
where BOM.BOMId == _FromBOM
{
newBOM.data(BOM);
newBOM.BOMId = _ToBOM;
BOMList.add(newBOM);
}
BOMList.insertDatabase();
}
}