Pass value with variable to subroutine

[cristian_av]

Hi

I'm Having some troubles with passing values to a subroutine.

This works:

	[ConsumosExcel]:
	LOAD * FROM ..\..\Datos\QVDs\Originales\ConsumosExcel.qvd (qvd);

CALL TransformarDatosEBI('ConsumosExcel','Consumos_EBI_Original');

But when i pass a variables, it's not working. It says "table not found". What I'm doing wrong??

Thank you!!!

	[ConsumosExcel]:
	LOAD * FROM ..\..\Datos\QVDs\Originales\ConsumosExcel.qvd (qvd);

END IF

SET vTablaOrigen1='ConsumosExcel';

SET vTablaDestino='Consumos_EBI_Original';

CALL TransformarDatosEBI($(vTablaOrigen1),'Consumos_EBI_Original');

[richard_pearce6 · Accepted solution]

If you put ' '  around your dollar expansion in the call statement that should resolve it..

CALL TransformarDatosEBI('$(vTablaOrigen1)','Consumos_EBI_Original');

[maxgro]

maybe with '  '

CALL TransformarDatosEBI('$(vTablaOrigen1)','Consumos_EBI_Original');

[richard_pearce6]

Great minds think a like Massimo !!