一次性打包插入数据库 RecordInsertList
                        
                            时间:2021-07-01 10:21:17
                            帮助过:19人阅读
							                        
                     
                    
                    
                    /*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(); 
	}}
一次性打包插入数据库 RecordInsertList
标签:插入数据   buffer   app   been   data   another   rap   height   amp