storing and loading local varaibles to and from qvd fileTable1

[#1]

Guys,

I have written this code to store some local variable in qvd and reload them back.

Table1:

Load * INLINE [

id, desc

1, One

2, Two

];

STORE Table1 into 'C:\test data\QVDs\Test.qvd';

DROP Table Table1;

Table2:

Load *

From 'C:\Test data\QVDs\Test.qvd';

It stores the values and when i go load them back then i see some strange behavior.

It shows that 124 lines are loaded back

and they seem to be XML version

What am I doing wrong here?

When i open the QVD file in QViewer then see rows correctly.

i.e.

1 One

2 Two

I tried

Table2:

Load id, desc

From 'C:\Test data\QVDs\Test.qvd';

but it says that FieldNames are unknown

[CELAMBARASAN]

Could you please attach the qvd created her?

[rbecher · Accepted solution]

You will need to add the file type in the LOAD statement:

Table2:

Load *

From 'C:\Test data\QVDs\Test.qvd' (qvd);

- Ralf

[Clever_Anjos]

STORE Table1 into 'C:\test data\QVDs\Test.qvd'(qvd);

[rbecher]

..this is the default (not really need) and not the cause of the issue.

[#6]

Thanks Ralf...it worked.