[Date Prev][Date Next][Thread Prev][Thread Next][Interchange by date
][Interchange by thread
]
[ic] completely removing orders
>> 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