Use @Store variable in sql statement Respondida

Nico Spruyt

 

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

Comentarios

2 comentarios

Iniciar sesión para dejar un comentario.