Interchange Developer Resource
[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



Search for: Sort by: