storing by fields

[#1]

Hi

I want to store just a few fields of a table

STORE

STORE

/%Clave,

TAFMOD, TAICCL, TAIFME, TAIINC, TAINDO, TAISOC, TAISUC, TAITDO, TAITTL, TAIUSR, TAUSRA,

%ClaveCircularCLDCCL as FECHABORRADO

FROM

CLDCCL

INTO

CLDCCL.QVD;

and for some reason it doesn't work. I don't se the mistake. Can somebody tell me why the execution fail?

Many thanks

[Miguel_Angel_Baeyens]

Hello,

You may do a load of those fields you want to store in a different table, then store the complete table:

ToFile:LOAD Field1, Field2 RESIDENT OriginalTable; STORE ToFile INTO FILE.QVD;DROP TABLE ToFile;

Hope that helps.