store into path with variables

[spikenaylor1]

here is my code

FOR vCount = 0 to NoOfTables()-1

LET vTableName = TableName($(vCount));

Let vFilelocation = $(vPathQVDExtract) & '000_Title_Extract_' & $(vTableName) & '.qvd';

STORE $(vTableName) INTO $(vFileLocation) (qvd);

Drop Table $(vTableName);

NEXT vCount

Cant get it to work

keeps giving me an error like

Syntax Error.

Unexpected token: '.', expected nothing

Any help please

[sasiparupudi1]

Try variables in quotes

STORE '$(vTableName)' INTO '$(vFileLocation)' (qvd);

[Chanty4u]

try this

STORE  $(vTableName) into  $(vFileLocation).qvd (qvd);

or

STORE  '$(vTableName)' &  ' into $(vFileLocation)'.qvd (qvd);

[tamilarasu]

Hi Mike,

Set vTableDrop = '';

FOR vCount = 0 to NoOfTables()-1;

LET vTableName = TableName($(vCount));
Let vTableDrop = '$(vTableDrop)' & If('$(vTableDrop)' ='','',', ') & '$(vTableName)';
Let vFileLocation = '$(vPathQVDExtract)' & '000_Title_Extract_' & '$(vTableName)' & '.qvd';

STORE $(vTableName) INTO [$(vFileLocation)] (qvd);

NEXT vCount

Drop Table $(vTableDrop);

[binujose1982]

Hi Mike,

Please give the file name within single quotes. Also remove all concatenation part.

Let vFilelocation = '$(vPathQVDExtract)000_Title_Extract_$(vTableName).qvd';

FOR vCount = 0 to NoOfTables()-1

LET vTableName = TableName($(vCount));

Let vFilelocation = '$(vPathQVDExtract)000_Title_Extract_$(vTableName).qvd';

STORE $(vTableName) INTO $(vFileLocation) (qvd);

Drop Table $(vTableName);

NEXT vCount

Hope this will help you.

Regards,

Binu