Although we will be using version 8 of VFP when released, at this moment in time, I am still using version 6.

Thanks
Kev

>>Has anyone got any effective methods for taking snapshots of data.
>>
>>I have one table, that has one-to-many relationships with quite a few tables. At certain points in the system, a snapshot of this table needs to happen, and the other tables will need to reference the [historical] data at the point in time the snapshot was taken.
>>
>>Hope that makes sense, we have many ideas to tackle this, but they all seem nasty, so I'm looking for a nicer way to do it.
>>
>>Any ideas?
>>
>>Thanks
>>Kev
>
>Kevin,
>For a similar need I did this :
>
>CursorToXML(...)
>oZipper.Compress(cXML)
>insert into SnapShots ... ;
>(SnapShotTakenAt, len(cXML), oZipper.CompSize, OrigCRC, CompCRC, oZipper.CompSTR)
>
>* Actually I took only processed parts representing updategrams in a way
>
>Cetin