Filtering Form

depro
depro Member Posts: 46
edited 2010-07-30 in NAV/Navision Classic Client
Hi Guys,

I have form wich contain Table Box and at the top I put some fields for filtering that Table Box.

Form has property:
SourceTable: Table1
SourceTableView: WHERE(Field1=CONST(No))


Every filter field contain Variable with accurate data type.

I`ve put code in OnValidate Trigeer in filtering field:
IF PrFilter <> '' THEN
  SETRANGE("No. Pr", PrFilter)
ELSE
  SETRANGE("No. Pr");

What i got in NAV:
When I try to use my filter it`s work only when filter value is in recordset in TableBox.
When I put other value in filter field in TableBox always left one record with incorrect data.

Any idea where is my mistake?


regards,
Depro

Comments

  • ufuk
    ufuk Member Posts: 514
    Add Currform.update(false) on OnAfterGetCurrRecord trigger.
    Ufuk Asci
    Pargesoft
  • depro
    depro Member Posts: 46
    Hi Ufuk,

    When I put your code in OnAfterGetCurrentRecord trigger i get error message while opening form:

    "There is insuffivient memory (stack) to execute this function.

    This can be due to the way that recursive function calls ora used in the program. Contact your system manager if you need assistance"
  • ufuk
    ufuk Member Posts: 514
    sorry you have to put it OnAfterValidate trigger of your filter field.
    Ufuk Asci
    Pargesoft

Categories