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

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.
 
K

KenB

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.


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?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top