that's cool, thanks a mil.
I also need to delete some data from the QVD file and I was wondering if it's possible to:
1. delete the data from the QV logical tables in memory with something like
SET Result = ActiveDocument.DynamicUpdateCommand ("DELETE Table FACT Where FAC_id_extraction = 20120316114852")
2. execute a store command to store the content of the table (after deletion) into the qvd file but I haven't ound any examples of calling a QV script from within a macro (whereas the opposite is quite common - i.e. calling a macro from a script). Is there any chance I can invoke a store command from within a macro?
Thanks a million,
I don't think it is easier, but we can do this by saving the deleted records IDs in a CSV or Excel file in macro, and during reload exclude this values by using Except(). Check script below
FROM FileName.qvd (qvd)
WHERE NOT EXISTS(FAC_id_extraction);
STORE DATA INTO FileName.qvd;
DROP TABLE DeletedIDs;
I was thinking about calling the Releoad method from within the macro.
However, this forces the re-execution of the entire reload script. Can I execute just a portion of the reload script and not the entire one?
If the answer is not, then I think I'll write a macro that does that:
- delete the rows from the SQL Server DB table
- execute a Reload from the macro
I will also have to modify the script to perform an insert/delete/update operation (as explained in the QV reference manual - using qvd for incremental load - case 4).
I was just trying to avoid to re-execute the entire script just to align the content of a qvd file with the database table after a few rows have been deleted.
Thanks a million and Best Wishes,