Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
Hi,
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
Klaus
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
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
Thank you Gysbert,
that worked wonderful.
Have a nice weekend
Klaus