Guest_imported
New member
- Jan 1, 1970
- 0
Hi,
I was wondering if anyone knows how to copy limit values from one unioned query to another.
The scenario is this: The first query uses for example Account Code and Date as variable limits. The the rest of the queries in the union use the same limits but I don't want to enter the limits but only once. So I want to pass the value entered from the first queries variable limit to the rest of the appended queries.
I have tried using OnPreProcess() event and can capture the value for the first limit but this only uses the the previous value entered, as the OnPreProcess() event for a given query occurs before the variable limit dialog box displays. So in effect the query must be run twice to update all the limit values of the appended queries.
To clarify this if anyone has used CorVu you can have the same prompts for multiple unioned queries and because they have the same prompt for each appended query CorVu only asked for the value once and passes down the appended query chain.
Thanks,
Nen
I was wondering if anyone knows how to copy limit values from one unioned query to another.
The scenario is this: The first query uses for example Account Code and Date as variable limits. The the rest of the queries in the union use the same limits but I don't want to enter the limits but only once. So I want to pass the value entered from the first queries variable limit to the rest of the appended queries.
I have tried using OnPreProcess() event and can capture the value for the first limit but this only uses the the previous value entered, as the OnPreProcess() event for a given query occurs before the variable limit dialog box displays. So in effect the query must be run twice to update all the limit values of the appended queries.
To clarify this if anyone has used CorVu you can have the same prompts for multiple unioned queries and because they have the same prompt for each appended query CorVu only asked for the value once and passes down the appended query chain.
Thanks,
Nen