Note the following:
Datatypeargument is set to
token, which means that the user-provided value is entered without any checking on the provided value.
Because checking is not performed on the value, the expression editor may indicate that the expression is not valid. When a valid user-provided value is supplied or if you provide a valid default value, expression editor will interpret the expression as valid.
Tokenshould be used only if there is a list of pick-values for the user.
DefaultTextargument is specified. Therefore, this is an optional prompt and
group by COUNTRYis used in the generated SQL.
Select COUNTRY_MULTILINGUAL.COUNTRY_CODE as COUNTRY_CODE, COUNTRY_MULTILINGUAL.COUNTRY as COUNTRY, COUNTRY_MULTILINGUAL."LANGUAGE" as LANGUAGE1, COUNTRY_MULTILINGUAL.CURRENCY_NAME as CURRENCY_NAME from gosales.gosales.dbo.COUNTRY_MULTILINGUAL COUNTRY_MULTILINGUAL #prompt('Sort column', 'token', 'group by COUNTRY', 'group by ' )#