Filter: field=Variable works once, then gives same result any Var

  • Thread starter Thread starter KenB
  • Start date Start date
K

KenB

Using the Macro ApplyFilter with a named query filter in a built-in Macro.
Query has the form Field=Temporary variable.
On first call, gives correct result but calling again with different value
in Variable gives the same result even after a ShowAllRecords Macro.
Using the query filter in isolation it works fine.
 
KenB said:
Using the Macro ApplyFilter with a named query filter in a built-in Macro.
Query has the form Field=Temporary variable.
On first call, gives correct result but calling again with different value
in Variable gives the same result even after a ShowAllRecords Macro.
Using the query filter in isolation it works fine.
Click to expand...


My question wasn't clear, let me try again
The following macros are run in order in response to various events:

ApplyFilter Field1="N" - shows about half my
file as intended
ApplyFilter Field2=TempVars!CurNo - shows records with CurNo
ApplyFilter Field1="N" - shows required records
SetValue TempVars!CurNo=some new value
ApplyFilter Field2=TempVars!CurNo - shows records with ORIGINAL CurNo

Do filters behave differently if the conditional expression involves a
variable?
 
Back
Top