Set Filter

jpnav

how to write code for setfilter

I want to setfilter item ledger entry table - with item table field1 = 'No'


Thanks

garak

Here two examples. A little Tip: read the Programming 1 und Programming 2 manuals.

Variables
ItemLedgEntry   Record Table 32
Item                Record Table 27

Item.get(PrimaryKeyValue);  //only one Item found
ItemLedgEntry.reset;
ItemLedgEntry.setrange("Item No.",Item."No.");
if ItemLedgEntry.findset then begin
end;

//or for more items

Item.reset
setfilter("No.",'%1|%2|%3','1000','1250','80010'); //Or a Filterstring instead of
if Item.findset(false,false) then begin //false = no modifications
  repeat  
    ItemLedgEntry.reset;
    ItemLedgEntry.setrange("Item No.",Item."No.");
    if ItemLedgEntry.findset(false,false) then begin
      repeat
      until ItemLedgEntry.next = 0;
    end;
  until item.next = 0;
end,

Regards

jpnav

Excellent!!

Working........

Thanks a lot.......