Level Extreme platform
Subscription
Corporate profile
Products & Services
Support
Legal
Français
Compressing text in a memo field
Message
From
16/01/2004 15:10:18
Dragan Nedeljkovich
Now officially retired
Zrenjanin, Serbia
 
 
To
16/01/2004 15:00:53
General information
Forum:
Visual FoxPro
Category:
Databases,Tables, Views, Indexing and SQL syntax
Miscellaneous
Thread ID:
00867574
Message ID:
00867624
Views:
23
>I have done some research on it, and found some vary basic approachs to doing LZW style compression and decompression. Have already written a simplified VFP version of it. But problem is really on the decompression side. The table need to be read and decompressed in a Active Server Page. This requires the decompression to occur in either a VBScript or Javascript language. I have completed the decompression code, and descovered that during the reconstruction of the original text, some text does not concatinate correctly. I have been working this for days now, and have not been able to get around this bug in VBscript or Javascript. For some reason the string "<A ", when added to a the of a string, disappears when the next piece (string) is added to the end of the string.
>
>Also, VBscript and Javascript have difficulty parsing a string of binary bytes. Some characters in the string simply are ignored, and next character in line is returned in its place.
>
>I am attempt to compress the database on my web site to conserve space. I only am allowed 100 meg of disk space. The database are growing and I need to shrink them.

In that case, find zlib.dll (and, recommended, the ocx that uses it). It has just two methods that you need to use, .CompressString() and .DecompressString(). It allows you to zip the string before storing it, and unzip when reading. Saved me a lot of space when I last tried it. And it can be used directly from Fox, no need for any wrapper.

back to same old

the first online autobiography, unfinished by design
What, me reckless? I'm full of recks!
Balkans, eh? Count them.
Previous
Next
Reply
Map
View

Click here to load this message in the networking platform