Forum Discussion
Insert Parameter in M language
Hi, I'm trying to build a Parameterised Query using M Language. I have my variables stored as text fields but when I add them to the final query, it doesnt seem to pick up the string but just ret...
Hi All,
So after many variations, it turns out it's the same as VBA without spaces. I was building a Paramaeterised Query and wanted a single place to change the value and it update the 6 Queries I have.
The Date value appeared like this "201801", so I created a variable and then managed to insert that using ""&Date&""
All working, thanks for you help. :)
The image you've posted is not an error-message, but a warning. If you click "Run", you should either get the desired result or an error-message. Please post that error-message if you need further help on that.
Thanks ImkeF , an honour to have you posting in the same thread! Thanks for all the effort you put in. :smileyhappy: