Gotcha – (qvd) is an important part of LOAD QVD syntax

 

When using a LOAD statement that targets a QVD file the typical syntax is:

LOAD

*

FROM

Qvd_path_filename.QVD (qvd)

;

 

Please don’t forget that “(qvd)” part. Even though the syntax of the LOAD command denotes it is optional and QVW will not complain about its absence, unpredictable things can happen in the LOAD statement when it isn’t stated.

 

Without it, you may see only a subset of my QVD rows returned even though no syntax is in place to restrict the rows returned.

 

Bad:

LOAD

*

FROM

[Qvd_path_filename.QVD]

;

may return only a small subset of rows

 

Good:

LOAD

*

FROM

[Qvd_path_filename.QVD] (qvd)

;

 

Other symptoms of when “(qvd)” is not used are the QVD’s XML header being read as text and not the binary contents of the QVD and the QVD file not being reported as inaccessible despite its existing and being accessible to QVW