Can we use WildCard character with SETRANGE function

Markandey_Pandey

Hi all,
Can we use wildcard character characters like * with SETRANGE.

I am trying this but not working any solution.

IF NoSeries = NoSeries::Job THEN BEGIN
RESET;
SETRANGE("No.",'JW*');
END;
IF NoSeries = NoSeries::Sales THEN BEGIN
RESET;
SETRANGE("No.",'SO*');
END;

here it should showing only JW* or SO*

lvanvugt

Why not use SETFILTER?

IF NoSeries = NoSeries::Job THEN BEGIN
  RESET;
  SETFILTER("No.",'JW*');
END;
IF NoSeries = NoSeries::Sales THEN BEGIN
  RESET;
  SETFILTER("No.",'SO*');
END;

DenSter

For multiple values of the same variable, use CASE:

CASE NoSeries OF
  NoSeries::Job:
    BEGIN
      RESET;
      SETFILTER("No.",'JW*');
    END;
  NoSeries::Sales:
    BEGIN
      RESET;
      SETFILTER("No.",'SO*');
    END;
  ELSE
    // for catching loose ends.
END;

When using multiple IF statements, it has to evaluate all IF statements. When using a CASE statement, it only evaluates one leg.

Savatage

// for catching loose ends.

:thumbsup: