rmh148
|
I have been using an SQL insert to load thousand of new BOM dynamically. I use VB to read excel or access data and create an GetBOM.sql files that I open and run in pervasive. This is a sample of one I just ran. INSERT INTO "BKBMMSTR" ("BKBM_PARENT", "BKBM_PROD_LINE^", "BKBM_COMPONENT", "BKBM_QTY_REQD", "BKBM_PROD_TYPE", "BKBM_PROD_SCRAP", "BKBM_PROD_OP", "BKBM_PROD_PRICE") VALUES ('207-2226-001/2',5,'FIT221V-1/4-0',0.2,'R',5,' 0',0)# INSERT INTO "BKBMMSTR" ("BKBM_PARENT", "BKBM_PROD_LINE^", "BKBM_COMPONENT", "BKBM_QTY_REQD", "BKBM_PROD_TYPE", "BKBM_PROD_SCRAP", "BKBM_PROD_OP", "BKBM_PROD_PRICE") VALUES ('207-2226-001/2',6,'0431164281',1,'R',5,' 0',0)# INSERT INTO "BKBMMSTR" ("BKBM_PARENT", "BKBM_PROD_LINE^", "BKBM_COMPONENT", "BKBM_QTY_REQD", "BKBM_PROD_TYPE", "BKBM_PROD_SCRAP", "BKBM_PROD_OP", "BKBM_PROD_PRICE") VALUES ('207-2226-001/2',7,'WIT-18SF',1,'R',5,' 0',0)# INSERT INTO "BKBMMSTR" ("BKBM_PARENT", "BKBM_PROD_LINE^", "BKBM_COMPONENT", "BKBM_QTY_REQD", "BKBM_PROD_TYPE", "BKBM_PROD_SCRAP", "BKBM_PROD_OP", "BKBM_PROD_PRICE") VALUES ('207-2226-001/2',8,'50-57-9011',1,'R',0,' 0',0)# INSERT INTO "BKBMMSTR" ("BKBM_PARENT", "BKBM_PROD_LINE^", "BKBM_COMPONENT", "BKBM_QTY_REQD", "BKBM_PROD_TYPE", "BKBM_PROD_SCRAP", "BKBM_PROD_OP", "BKBM_PROD_PRICE") VALUES ('207-2226-001/2',9,'16-02-0087',14,'R',0,' 0',0)# INSERT INTO "BKBMMSTR" ("BKBM_PARENT", "BKBM_PROD_LINE^", "BKBM_COMPONENT", "BKBM_QTY_REQD", "BKBM_PROD_TYPE", "BKBM_PROD_SCRAP", "BKBM_PROD_OP", "BKBM_PROD_PRICE") VALUES ('207-2226-001/2',10,'641994-1',1,'R',10,' 0',0)#
|