>Hi...
>I could use some expert help here...
>
>Please note the following code...
> CREATE TABLE &cLocalDB FROM ARRAY aFlds
>
> nSelect = SELECT(0)
>
> SELECT MAIN
> GO TOP
>
> DO WHILE NOT EOF()
> SELECT (nSelect)
> APPEND FROM &cNetDB FOR Mainkey == MAIN.Mainkey
> SELECT MODACAD
> SKIP 1
> ENDDO
>
>The idea is as I loop through the main database
>MAIN I can find the matching records for each mainkey
>and append them into a local copy of the data.
>
>Even if there is no mainkey's in the table I append from (cNetDB)
>the FPT file becomes very huge (like 420 MB)
>
>In some cases...
>
>The question is why?
VFP doesn't reuse blocks of of disk freed in the FPT when a new value is assigned to a memo field apparently. PACK MEMO may well noticably shrink the size of the FPT - you can make sure of this by copying the file and comparing thw size of the copied .FPT with the original .FPT file size.