Jan 5, 2011 #1 dmrVA IS-IT--Management Joined Jul 22, 2003 Messages 164 Location US 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
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
Jan 7, 2011 #2 dgillz Instructor Joined Mar 2, 2001 Messages 10,059 Location US 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 Upvote 0 Downvote
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