Deleting Bills of Materials

[dmrVA]

Is there anyway to delete a BM without having to delete every individual item? I have lots of parts to delete to clean up the database.

THanks

 

[dgillz]

Write a SQL script:

DELETE from bmprdstr_sql
WHERE par_item_no in ('PARENT ITEM A','PARENT ITEM B',...)

This will work in Pervasive as well.

Software Sales, Training, Implementation and Support for Macola, Synergy, and Crystal Reports. Check out our Macola tools:

http://www.gainfocus.biz/exceladdin.html