Use @Store variable in sql statement

Respondida

Nico Spruyt

• 25 de julio de 2019 12:42

 

Hi;

 

How can we execute following sql statement in a Macro?

 

Transfer(SQL:SELECT SUBSTRING('$[$10.0.0]',3,2) + SUBSTRING('$[$10.0.0]',5,2) + T0.U_Value3 FROM [@PMX_EUM_PALI] T0 WHERE T0.Code ='LINK_TAXTYPE_SERIES' AND T0.U_Value ='@STORE23' AND U_Value2='@STORE22' AND U_Code='13'|STORE24);

 

 

Kind regards,

 

Nico Spruyt

Vote

0

• Comentario oficial

  

  Yaremi Miranda Lopez

  • 18 de febrero de 2020 17:54

  Hello Nico,

  In the latest version you can use @STORE variables in the most common Universal Functions, here is the download and more detail:

  https://support.boyum-it.com/hc/en-us/articles/360005579097-B1UP-2020-02-HF01-is-now-released
• 

  Yaremi Miranda Lopez

  • 17 de febrero de 2020 18:51

  Hello,

  What is the problem with the command?

Iniciar sesión para dejar un comentario.