Delete a record in a QVD file

[jasonseril]

Hello all,

How should i delete a record in a qvd file?

Thanks in advance and more power!

Jason

[Miguel_Angel_Baeyens]

Hello Jason,

As loading from a QVD is pretty fast, I'd suggest you to load all records in that file except for the one you want to delete, then store it in the same file:

NoRecord:LOAD * FROM FILE.QVD (QVD)WHERE RECID <> 'XXX'; STORE NoRecord INTO FILE.QVD;

Where XXX is the ID for the record (or any other condition) you don't want to save.

Hope this helps.

[jasonseril]

ok miguel, that was a fast reply. thanks again, it helps a lot.

jason