API QUESTION DROP TABLE

[#1]

Dear all,

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:

Sub Droptables

set doc=ActiveDocument

for i=0 to doc.GetTableCount-1

name = doc.GetTableName(i)

'doc.deletetable(name)

next

end sub

[prieper]

Why don't you do it in the script:

DROP TABLE YourTable;
or
DROP TABLES YourTable1, YourTable2;

HTH
Peter

[stephencredmond]

Hi,

Not sure you can do this via the API. However, what is stopping you doing it at the end of your script?

Regards,

Stephen

[#4]

Dear,

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.

Best regards.

[llauses243]

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)

[#6]

Dear Luis,

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.