Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

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...
Need Help
  • Anonymous's avatar
    Anonymous
    7 years ago

    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. :)

Anonymous's avatar
Anonymous
Not applicable
7 years ago

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. :)

tmarton's avatar
tmarton
Helper I
6 years ago

This worked for me but had to enter as ""&request)), that was the name of my parameter