Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations bkrike on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
BOM Mass Delete
- Thread starter bcygan
- Start date
- Thread starter
- #3
Run a simple SQL delete query:
DELETE from BMPRDSTR_SQL
WHERE comp_item_no="fill in the blank"
Repeat as needed for other components.
Obviously you need to backup this file before doing this.
Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
DELETE from BMPRDSTR_SQL
WHERE comp_item_no="fill in the blank"
Repeat as needed for other components.
Obviously you need to backup this file before doing this.
Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
- Thread starter
- #6
You should run a reset low level codes process after this, particularly if you are using MRP or SPC.
Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:
- Status
Similar threads
