Delete all lines that satisfy condition?

Tiwaz

Hi guys. I want to use action (button) on my header page to delete all lines that satisfy that value of a field is, for example, "1".
For example I have some lines
Int....1....34589....
Int.....4....56764...
Text...1....64776...
And I want to delete those that have value "1" in second field.
How to do this

Kishorm

Use the DELETEALL command for better performance, e.g. ....

Linetable.SETRANGE("Second Field", 1);
Linetable.DELETEALL;

...the above code assumes the the field is called "Second Field" and is a numeric field, e.g. Integer or Decimal

guidorobben

use a SETRANGE on second field. See the delete of table 36.

Sowkarthika

You can code your requirement in the Page Action. If you want more details, then elaborate more on your requirement.

RockWithNAV

Write something like this

Linetable.SETRANGE(Second Field, Value 1);//Add all specific filters with tje Order No and all
Linetable.FINDSET
REPEAT
Linetable.DELETE;
UNTIL Linetable.NEXT=0;

Kishorm

Use the DELETEALL command for better performance, e.g. ....

Linetable.SETRANGE("Second Field", 1);
Linetable.DELETEALL;

...the above code assumes the the field is called "Second Field" and is a numeric field, e.g. Integer or Decimal

Tiwaz

Thank you for your help!

Jan_Veenendaal

oops, sorry.