Insert_Recordset

Insert_Recordset copies data from one or more tables in one call to the database.
This is much faster than selecting records individually and then inserting the new
records in to the table.
In the following example, Isaac has been asked to copy all Employee records to
the vendor table for the purposes of being able to pay expenses to the employee.
Only specific information, such as name and address needs to be copied.

1 2 3 4

VendTable vendTable; HcmWorker hcmWorker; Insert_RecordSet VendTable (accountnum, Party) select PersonnelNumber, person from HcmWorker;

Best Regards,
Hossein Karimi