>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
Check Craig Boyd's VFPCompression library. It can compress not only files but strings also.
http://www.sweetpotatosoftware.com/SPSBlog/SearchView.aspx?q=VFPCompression
Against Stupidity the Gods themselves Contend in Vain - Johann Christoph Friedrich von Schiller
The only thing normal about database guys is their tables.