Skip to Content
Former Member
Dec 09, 2008 at 10:10 AM

Define constant in query 3.5


In the moment I use a hierarchy variable and fill this variable via VBA makro. ( I have 4 different values (hierarchy nodes) for the variable)) But the customer wants to avoid VBA makro.

The variable is used in a row structure different times.

The variable should get a fixed value inside the query at one place. (Use default value is not an option) and then 4 different queries with different values should be stored.

So I want to use a constant instead of a variable. But where to define a constant (as used in a programming language) in the query designer 3.5 ? Or is there an option in query designer 7.0 ?

There exits u201Cconstant selectionu201D but this brings no solution here.

In cell definitions there is the possibility to use a help cell (on the low left) and reference on that cell in other cells. But this works only in the cell grid. Outside this help cell canu2019t be referenced.

Hope someone was an idea u2026..