>Hello all,
>
>I am seeking tips and/or sample code on how to use a compression add-on .DLL such as DynaZip or Xceed to compress the contents of a memo field. I can perform this task by using STRTOFILE(memo_field,lcfile), ZIPping the file, and then using FILETOSTR() to copy the file contents to the memo field. But, I would like to implement a more elegent and speedy solution that does not write to disk. The app would be reading the memo from one table and writing the compressed memo to another.
>

Dana,

Maybe a stupid question, but would it really help to compress a Memo field ?
Of course it depends on the data in it, but assumed it's about normal text there isn't all that much to gain I think. Remember, a Memo is unlike a DBF (containing lots of air), and all the data is right after each other.

On testing, don't get confused by looking at the results from your compressed memo opposed to the original, whereas the original may contain numerous "copies" of updated data (text). Hence it would be far better to have some solution for the memo to have the old data out of there (i.e. pack it regularly).

But anyway, could you tell what "data" is in there, and what (how much) is there to gain ? could be useful ...
Thanks,