2 Replies Latest reply: Jun 7, 2013 7:25 AM by Klaus Kring RSS

    rescue old data from qvd



      I got an old qvw which displays data, that I cant reload from source, because source data has gone.

      Is there a chance to store or extracts old data from the qvw?


      Thanks in advance


        • Re: rescue old data from qvd
          Gysbert Wassenaar

          You can use the binary statement to load data from a qvw file into another qvw file. You can then store the data into qvd's if you want (or in csv). The binary statements has to be the absolute first line in your script. You can use something like below to load the data from a qvw file and create qvd's for every table. Change your.qvw and c:\temp\extract to what's appropriate for you.


          BINARY your.qvw;

          Directory c:\temp\extract;

          FOR i = 0 to NoOfTables()-1

                    LET vTableName = TableName($(i));

                    LET vOutfile = '$(vTableName).qvd';

                    STORE [$(vTableName)] INTO [$(vOutfile)] (qvd);

          NEXT i