[ic] completely removing orders

Dennis Chen interchange-users@icdevgroup.org
Wed Oct 30 17:48:01 2002


> I have a few test orders that are about 500 order numbers 
> higher than the
> current number in the order number progression that I need to have
> completely wiped out so they don't interfere with the real 
> order numbers
> when they get there.  How can I do that?  I think I need more than
> deleted=1.
> 

can't you do a sql delete if you're using a sql database like mysql?
something like
    delete from transactions where order_number > 'TEST00500';
    delete from orderline where order_number > 'TEST00500';
which will delete all order numbers greater than 500

hope that helped :)
Dennis