General information
Category:
Coding, syntax & commands
Hi Sergey,
I have used the PACK command, and the PACK MEMO on the original table (table1).
Then I use the following commands:
*************************************
use table1
use table2
append from table1 for id = 123
*************************************
table 2 will be populated with all records with id = 123, and you can access their corresponding memo files.
The table2.dbf file looks fine, but the table2.fpt file looks like it is an exact copy of the table1.fpt file (very big). I belive what is taking time is the copying in to the fpt file one record at the time.
I can PACK MEMO on table2 when all the copying is done. This will get rid of all the excess memo fields(Making the fpt file the "right size"), but I don't belive this is how it is suppose to work.... It takes way to long!!
The reason I am using the Append command is that some of my tables have General fields, and I was looking to work with as generic code as possible.
Cicilia
Previous
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