Setrange with another table

Answers

• Options

  rahul_jnk Member Posts: 61

  2017-04-06

  Have you looked into COPYFILTER function?
  https://msdn.microsoft.com/en-us/library/dd355214.aspx

  0
• Options

  sharon95 Member Posts: 183

  2017-04-06

  yes, but the two tables are different...

  0
• Options

  rahul_jnk Member Posts: 61

  2017-04-06

  It will work when tables are different but on one condition that data types must match.
  
  From the documentation:
  The FromFields and ToFields must be of the same data type, but they do not have to belong to the same table.

  0
• Options

  Wisa123 Member Posts: 308

  2017-04-06 edited 2017-04-06

  Table1.setrange(name, "peu*");
  IF Table1.FINDSET THEN REPEAT
  Table2.setrange(name,Table1.name)
  IF Table2.FINDSET THEN REPEAT
  table2.mark(true);
  UNTIL table2.next = 0;
  UNTIL Table1.NEXT = 0;
  
  Table2.MARKEDONLY(true);
  
  -> Findset now delivers all the things you need now.
  Assuming i understood your problem
  there may be better options to solve this though.
  
  For more info lookup the mark function on msdn
  

  Austrian NAV/BC Dev

  0
• Options

  Albertvh Member Posts: 516

  2017-04-07

  Or you could do this
  Table2.SETFILTER(Name,Table1,GETFILTER(Name));
  IF Table2.FINDSET THEN ....

  0