mutiple table Load error

[didierodayo]

Hi All,

am tryng to load multiple table from Sql with the script below. The script works fine and loads all the table which it stores into qvd but in the end I receive the following error.

Tables:
Load * Inline [name
table1
table2
table3
table4
table5
];

For i = 1 to NoOfRows('Tables')
Let TN = Peek('name',$(i),'Tables');
TRACE Processing File: $(TN).qvd;
$(TN):
LOAD*;
SQL SELECT *
FROM $(TN);

STORE $(TN) into $(vQVDExtractPath)Tables_$(TN).qvd (qvd);
Drop Table $(TN);
Next i;

ErrorCode:

Unknown statement

:

LOAD*

Any idea why I am receving the error in the end?

Thanks

[Anil_Babu_Samineni]

May be declare this statement like

Select * from ...;

Load * resident $(TN);

[didierodayo]

Hi Anil that is also returning the same error.

For i = 1 to NoOfRows('Tables')

Let TN = Peek('name',$(i),'Tables');

TRACE Processing File: $(TN).qvd;

$(TN):

SQL SELECT *

FROM $(TN);

LOAD* Resident $(TN);

STORE $(TN) into $(vQVDExtractPath)Tables_$(TN).qvd (qvd);

Drop Table $(TN);

Next I;

[kenphamvn · Accepted solution]

Hi

Please try this

For i = 0 to NoOfRows('Tables') -1

instead

For i = 1 to NoOfRows('Tables') -0

[didierodayo]

Thanks An, that is what it was.