A parameter map that nests prompts
Note the following:
- In the model, there is a parameter map DynPromptLabels with
#$PromptLabels{$language}#
- Part of the prompt information is run from a parameter map instead of being coded directly inside the SQL.
- The whole macro containing the prompt can be a value in a parameter map.
select
ORDER_METHOD.ORDER_METHOD_CODE as ORDER_METHOD_CODE,
ORDER_METHOD.ORDER_METHOD_#$language#
as ORDER_METHOD_EN
from
gosales.gosales.dbo.ORDER_METHOD ORDER_METHOD
#prompt($DynPromptLabels{'ex9'},
'',
' ',
'where ORDER_METHOD.ORDER_METHOD_' + $language + '
>'
)#