Search value

Comments

• lakshmivalluru Member Posts: 168

  2007-02-15

  @test

  LR

  0
• kljinnn Member Posts: 23

  2007-02-15

  and where do i have to paste that @?
  i dont find it. this is my code
  
  
  IF gemeenteschool <> '' THEN BEGIN
  RESET;
  SETCURRENTKEY(Gemeente);
  SETRANGE(Gemeente,gemeenteschool);
  CurrForm.UPDATE(FALSE);
  END

  0
• SteveO Member Posts: 164

  2007-02-15

  You need to use SETFILTER instead of SETRANGE.
  SETRANGE will only look for literal values, SETFILTER allows you to use wildcards and other filter characters.
  
  Here is some info from the online help for SETFILTER

  This example...
  Means...
  
  A..Z
  A range from A to Z
  
  A | G
  A or G
  
  F.. & *A/S
  A range from F and A/S is included in the field.
  
  <>B
  All except B
  
  <>''
  All not blank
  
  <=200 | >500
  All less than or equal to 200 or greater than 500
  
  
  Using a filter with replacement field:
  
  This filter selects all accounts in the range from 100 to 200 and No. 300
  
  "G/L Account".SETFILTER("No.", '%1..%2|%3', '100', '200', '300');
  
  Using a filter entered directly in a string:
  
  This filter, which is entered as a string, corresponds to the previous example. It too selects all accounts in the range from 100 to 200 and No. 300.
  
  "G/L Account".SETFILTER("No.", '100..200|300');

  This isn't a signature, I type this at the bottom of every message

  0
• kljinnn Member Posts: 23

  2007-02-15

  ok, thanks it works.
  thank you

  0