Logical expression OR on Form propertis

Comments

• Options

  sourav_ait Member Posts: 15

  2014-11-20

  Not possible through sourcetableview. You can not have contradictory condition with in it. Try using some coding on Onopen() trigger of the form.

  0
• Options

  tinoruijs Member Posts: 1,226

  2014-11-20

  No, that's not possible.
  To achieve this, you must mark records which you want to show and then open the form.

  ---

  Tino Ruijs
  Microsoft Dynamics NAV specialist

  0
• Options

  IvonaK Member Posts: 114

  2014-11-21

  Thanks a lot.

  0
• Options

  jlesage Member Posts: 3

  2014-11-21

  you could set SourceTableTemporary to Yes
  then in onOpenForm select the record needed
  
  
  Item.RESET;
  IF Item.FINDSET THEN
  REPEAT
  IF (COPYSTR(Item."No.",1,1) = '0') OR
  (COPYSTR(Item.Description,1,1) = 'A') THEN BEGIN
  REC := Item;
  INSERT;
  END;
  UNTIL Item.NEXT = 0;
  
  If the table is not too big.

  0
• Options

  IvonaK Member Posts: 114

  2014-11-23

  Thanks a lot.

  0