Discussion Board for collaboration related to QlikView Deployment.
I have a qvw file only for reload and execute macros.
After execute all I want to drop all tables.
I have that sub but i don't know how ho drop tables:
for i=0 to doc.GetTableCount-1
name = doc.GetTableName(i)
Why don't you do it in the script:
DROP TABLE YourTable;orDROP TABLES YourTable1, YourTable2;
Not sure you can do this via the API. However, what is stopping you doing it at the end of your script?
after reload, I'm executing a Macro that is doing some export.
After that, I want to clear all the data and save the file.
File is loading from another QVW and it's near 2 Gigs, and I don't want to have all the data on the file because it's reloading every day and i don't need the data.
Hi Jordi ,
If drop all tables the document (.qvw) useful zero only schema
Left macro for clear data & save document , to apply OnClose
Good luck, from Spain, Luis (0034657486722)
thanks for your answer but How I can execute macro OnClose (I don't have that option to select on document propierties)
Saludos desde Barcelona.