General information
Title:
Memo File is Extemely big with repeated APPEND FROM
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?
Next
Reply
View the map of this thread
View the map of this thread starting from this message only
View all messages of this thread
View all messages of this thread starting from this message only