Checking Filter on Table through Code....

prasad.khorgade

Hi..

If I am filtering table data & fetching it on form or Report.
So while coding How can I check the wheather the filter is applying on Table Data or not?

Luc_VanDyck

IF Rec.GETFILTERS <> '' THEN
  MESSAGE('You have applied filters');

garak

RecVariable.getfilters <- gives you all filters of the Recvariable as string
RecVariable.getfilter(Field) <- gives you the filter of a selected field as string

Regards

Lee_Durrant

You may also need to check the FILTERGROUP, depending on how and where you are filtering:

FOR i := 6 DOWNTO 0 DO BEGIN
FILTERGROUP(i);
MESSAGE(FORMAT(i) + ' ' + GETFILTERS);
END;

prasad.khorgade

Thanks For your reply Guys...