>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.
Try to open DBF exclusively and issue a pack memo command. Also check set blocksize command.
If it's not broken, fix it until it is.
My Blog