[ic] completely removing orders

Grant interchange-users@icdevgroup.org
Wed Oct 30 20:50: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

I'm using the default DBM database.  I should have mentioned that.  Thank
you though!

- Grant