>Hi all
>
>My app is VFP9 on MSSQL database.
>
>I store contents of text files in memo field of a table using APPEND MEMO myfield FROM txtfile OVERWRITE
>
>I need to find out how I can compress a text file so I can store the compressed file into the memo field so that I can improve my app performance when I retrieve data from the table containing the memo field.
>
>Your advice much appreciated
>
>Thanks & Best Regards

I agree with using the vfpCompression.fll. But from experience I had a few problems. First, the resulting compressed string cannot be writen out to a file directly. It does not have the needed header to allow zip-type application to recognize it. It can only be managed with the utility itself. Second, when we used it excessively, we started to experience C5 errors. There appeared to be a memory leak occuring. Now, with hope, these issues have been addressed in the last few years, and the current version is more stable. Sorry, just speaking from experience.