Options

FILTERGROUP on INSERT

slmaluwaslmaluwa Member Posts: 358
While doing an upgrade, i came across this piece of code in OnInsert trigger of a table
  FILTERGROUP(2);
  "Location Code" := GetAllowedLocationFilter();
  FILTERGROUP(0);

Based on the customisation elsewhere in the DB, I think this was done to save the allowed location code irrespective of selected location code. I think this is a bad idea and the filter should have implemented in the form.

will the above FILTERGROUP stuff work on a table?
"A bove maiore discit arare minor"-"From the old ox, the young one learns to plow."

Comments

  • Options
    SiStSiSt Member Posts: 46
    With just the few lines of code it is hard to guess what the code does. The FILTERGROUP works on the record, regardless if it is used in the table, form, page etc.

    The first FILTERGROUP command switches to the filter group 2. I think the command GetAllowedLocationFilter will read out a filter set in this group and assigns it to the "Location Code" field. Afterwards it switches back to the default FILTERGROUP.

    FILTERGROUP 2 is usually used in Forms.

    So my guess: If you're in a form or subform with a TableView or DataItemLink and you insert a new record, then the value from the filter is used to set the "Location Code" field to the filtered value.
Sign In or Register to comment.