vwitzel

Bulk UnitBatch and Batch Deletion

Discussion created by vwitzel on Sep 4, 2013
Latest reply on Sep 10, 2013 by hanyong

Hi all,

 

I am facing a situation where a module containing PIUnits was deleted from the MDB prior to all child UnitBatches having been deleted. What is the best way to resolve this situation? My understanding is that I could potentially write a macro using the PI SDK to find all of these problem UnitBatches, or potentially use the PI SQL Commander (part of the PI OLEDB Provider) to do the same. Could anybody share their experiences and/or code / queries with me to accomplish this?

 

Much appreciated!

 

-Vincent

Outcomes