Hi
Help please,
I have table with memo file (.fpt) 1.5 GB.
I try to reduce it for voiding VFP 2GB file limitation.
The table is log info without user intervention.
I took a look on the memos and I discovered that all rows share the all following:
1. One line (no records with chr(13/10)
2. Maximum length is 65 characters (length of the most rows is 11).
3. The row contain lot of extra spaces, especially in the end
To examine the options for reducing the file without spending few hours for each test, I deleted the vast majority of the dbf file, and I was left with fpt file of 2,500 KB
.
I ran the following code:
use logs exclusive
select logs
scan
cmsg=allt(logs.msg)&&memo
replace msg with cmsg in logs
endscan
The code runs great, but there is one small problem, the size of the fpt file is now 3,800 KB.
Thank you
Chaim