Hi all,
After constructing my model (tables); my main purposes were:
1) Store all tables in QVDs:
FOR i = 0 to NoOfTables()-1
LET vTabName = TableName($(i));
STORE $(vTabName) into [lib://blabla/QVD/$(vTabName)$(vSaveFile).qvd] (qvd);
NEXT i
2) drop all the tables (after storing them in qvds) :
//drop tables
FOR j = 1 to NoOfTables()
LET vTabName2 = TableName($(j));
Drop table "$(vTabName2)";
NEXT j
The problem is that the first part (storing the tables works perfectly) while the second one does not.
In fact, from the 15 tables I have, some are deleted and nearly the half ARE NOT.
I have tried :
Drop table "$(vTabName2)";
Drop table '$(vTabName2)';
Drop table $(vTabName2);
Drop table vTabName2;
Nothing works as expected...
When I try the same script with inline tables, all is deleted !
Any idea on what could be the cause of such a behaviour? Thanks
