QVD files

[#1]

Dears

I was created a QVD files from a chart and save in my PC,Now if i want to update data to QVD files from my data base how it would be possibe

As i am new to this area please tell me what are the advantages of using QVD files

If we are working by using a QVW file it is enough or we need to make use of QVD file also

Faisal

Chennai

[Miguel_Angel_Baeyens]

Hi Faisal,

There are a lot of good documents and white papers on why use the QVD files and how. In regards to your question, I'd do a two step load, like the following:

// This loads the existing data in your QVD file
Original:
LOAD *
FROM File.qvd (qvd);
// This loads today data and appends its records
// to the table above
FromSource:
CONCATENATE (Original) LOAD *;
SQL SELECT *
FROM Database
WHERE Date = '20111220'; // Or whatever source or condition you use to get new records
// Now both the old data and today data are stored into the same QVD, so tomorrow
// the LOAD will be the same
STORE Original INTO File.qvd (qvd); 

Hope that helps.

Miguel