QV9 SR2 Changes to QVD format !

[#1]

I have a collection of historic QVD's I have now succesfully exported to CSV

We have currency symbols on the Currency columns exported however where the old QVD Source file was an 8.5 version we dont. this causes a problem when we try to import all the CSV files as they are in different formats although they were generated with the same routine at the same Time.

We have found that the Cause is that the QVD header is Different the Newer QVDS contain a currency Format string in the Header that is not present in the old QVD's

<QvdFieldHeader>
<FieldName>PLU_PRICE</FieldName>
<BitOffset>14</BitOffset>
<BitWidth>8</BitWidth>
<Bias>-2</Bias>
<NumberFormat>
<Type>12</Type>
<nDec>0</nDec>
<UseThou>1</UseThou>
<Fmt>£###0.00;-£###0.00</Fmt>
<Dec>.</Dec>
<Thou></Thou>
</NumberFormat>
<NoOfSymbols>147</NoOfSymbols>
<Offset>490810</Offset>
<Length>1155</Length>
</QvdFieldHeader>

We can ensure this doesnt get into new files by changing the SET Statement on the Load Script.

But How can this be easilly removed from the Existing QVD's Without needing to ReLoad the Data.

We have found that even when we set the currency format to exclude the currency sign and then Load an existing QVD the Currency Symbol is Retained in its original format. this appears to be a Bug

ColinR