aout qvd files

[#1]

hi

i am ravikumar from ajzaas solutions

my query is

Is it possible to generate a qvd file automatically if it was not present in the application , If possible send the details about the process clearly

[Miguel_Angel_Baeyens]

Hi,

QVD (storage) files are not QVW (analysis) files. In the script of any QVW file you create, you can set a STORE instruction to create a file in your filesystem, provided you have proper permissions to write in the folder, and create a QVD file with one table in it. Each time a reload takes place, if there are no conditionals affecting the process, the STORE command will be executed and the new loaded table will be saved in the same place.

Customers:LOAD Field1, Field2;SQL SELECT Field1, Field2 FROM Database.owner.table; STORE Customers INTO C:\Customers.qvd;

Hope that helps.

[gauravkhare]

Dear Ravi,

if you have mentioned in your script the procedure for the creation of qvd's only they will generate.

eg:store ravi(tablename) into c:ravikumar/ravi.qvd....

so whenever your reload takes place then the qvd will be generated.