Delete all lines that satisfy condition?

Answers

• Options

  guidorobben Member Posts: 157

  2016-10-04 edited 2016-10-04

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

  0
• Options

  Sowkarthika Member Posts: 102

  2016-10-04

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

  0
• Options

  RockWithNAV Member Posts: 1,139

  2016-10-04

  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;
  
  

  Thanks
  
  Blog - rockwithnav.wordpress.com/
  Twitter - https://twitter.com/RockwithNav
  Facebook - https://facebook.com/rockwithnav/

  0
• Options

  Kishorm Member Posts: 921

  2016-10-04 Answer ✓

  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
  

  6
• Options

  Tiwaz Member Posts: 98

  2016-10-05

  Thank you for your help!

  0
• Options

  Jan_Veenendaal Member Posts: 206

  2016-10-05 edited 2016-10-05

  oops, sorry.

  Jan Veenendaal

  0