Hi,
Is it possible to add dynamic messages to a message with only 1 parameter?
What I have:
If I remove the parent text tag then I only get the first column translation and the rest is ignored which is not what I want.
Is there any way of making this work?
-Thanks
Best answer by Erwin Ekkel
View originalThe col tag needs to be outside the text container and needs to have it’s own parameter so in this case you would need {0}{1}{2}
Here is an example for a parameter a column name and another parameter.
set @xml = concat('<text>', @stock,'</text>
<col tabid="address" colid="street" transl="grid"></col> '
,'<text>', @art_number, '</text>')
+23
Adding to what my colleague said, you can also force the parameters to be on a newline by editing the Message translation in the form, then typing:
{0}
{1}
{2}Forcing a newline can be done by using the keyboard shortkey: Alt+Enter
I added the necessary parameters and it works great!
But now my issue is that I can only this message if I have 3 parameters to send through. I would’ve liked if I could specify one parameter in the message itself to keep it general. This way I could send a nested message as parameter via the control procedure and not be limited to 3 parameters.
Is there a way to achieve this?
+23
You can attach one XML tag like <text> or <col> to one parameter like {0} and {1}. What you can do is append the text together into one parameter like so:
declare @msg_text varchar(100)
select @msg_text = '<text>' + @text_1 + @text_2 + @text_3 + '</text>'
This will then show the three texts together in 1 parameter. You can add these to your texts to for newlines:

Do keep in mind that the texts cannot contain any characters XML doesn't support, like the character &. These characters need to be replaced. For example:
I was hoping for the ability to use multiple XML tags as one parameter (nested), but I guess I can still make it work with the above suggestions.
Thanks!
Enter your username or e-mail address. We'll send you an e-mail with instructions to reset your password.