Delete multiple lines in the same sales order

sbilly · 2012-08-10

Hi all,
I want to create a function that deletes multiple lines in the same sales order. How can I push the system to delete selected lines ( selection with ctrl button) like we select lines with ctrl and push the delete button of the keyboard.
Any suggestions please?

vijay_g · 2012-08-10

First, Why you want to do this..?

what you have tried till now? There should not be any problem if you are technical.

sbilly · 2012-08-10

To answer ur first question:
After importing many sales lines from a csv file, I want to delete some of them in the same time.

My problem is how to make the system delete only the selected lines (selection with ctrl)

vijay_g · 2012-08-10

Make a button and write this code on Onpush trigger.

CurrForm.SETSELECTIONFILTER(RecVar);
RecVar.DELETEALL;

RecVar is Variable type of record(36,37);

sbilly · 2012-08-10

Thanks for help

David_Singleton · 2012-08-10

vijay_g wrote:
Make a button and write this code on Onpush trigger.
CurrForm.SETSELECTIONFILTER(RecVar);
RecVar.DELETEALL;
RecVar is Variable type of record(36,37);

[-X

Please do not do this, this code can corrupt your database.

Reinhard · 2012-08-10

David, can you provide any more info on that? Seems like that would be an important thing to know!

sbilly · 2012-08-14

Hi David,
Please tell me why this code can corrupt the database?

David_Singleton · 2012-08-14

Create a sales order.

Ship any line.

Now run your code.

The database is now corrupt.

And this is just one example, the simplest, there are plenty more cases where this code will corrupt the database.

David_Singleton · 2012-08-14

vijay_g wrote:

_________________
Vijay Gupta
Changing the code is last step. Try to change processes first...

Vijay,

please read your signature, in it lies the correct solution to this question.

sbilly · 2012-08-14

Thank you for the clarification, if I understand, this code will delete any thing in the database without respect of navision rules?

MBerger · 2012-08-14

Why not use Deleteall(true) ?

dans · 2012-08-15

why do you need a delete button to delete the selected lines ???

Delete multiple lines in the same sales order

Comments

Categories