General information
Title:
Copying records from one table to another in FPW 2.6
I have a routine that copies records from one table to another. Sounds simple, but when APPEND is used, the size of the tables exceeds the available memory and cause a Stack Fault.
I rewrote it so that the records write over existing records (based on matching criteria) using SCATTER MEMVAR and GATHER MEMVAR and use a INSERT - SQL if more records are needed. The problem is that this takes a long time. I can watch the records being written over. The matching criteria is by State and if I have a lot of states to copy, it is painful. (Even one state is painful.)
Anyone have any better ideas?
Sarah
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