>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?
You could investigate SET BLOCKSIZE TO 0. In some cases this can improve the storage efficiency of memo fields.
Regards. Al
"Violence is the last refuge of the incompetent." -- Isaac Asimov
"Never let your sense of morals prevent you from doing what is right." -- Isaac Asimov
Neither a despot, nor a doormat, be
Every app wants to be a database app when it grows up