I have a project where we have developed a UserMacro that is supposed to return a comma-separated list of ProductNumbers based on some information in a custom table. Nothing fancy so far.
Setting up the Macro in the query worked pretty well, and we got the desired outcome.
The problem comes after the application recycles. If the application recycles the query expression is not applied unless I run the index again.
It is a weird behavior since the query and the index should not be connected but it is happening nevertheless.
I have checked the value returned by the Macro and it is identical both before and after the recycle.
Here is the code that we have used:
Can anybody tell me what is wrong with our code?