>Cetin,
>
>If the APPEND FROM table is large, this will be *very* slow, correct? Won't it it make an entire pass through puncharcactualdata each time through the loop?
>
>>
>>select punchactualdata
>>append from puncharcactualdata for jobnum=punchheader.jobnum
>>* Delete from puncharcactualdata where jobnum=punchheader.jobnum
>>
>>Cetin
No loop there. One pass.
Scan for ... has the same drawback + as it hits a record it should populate the variables first. Append from execution should be faster (especially if no indexes on target).
PS: If VFP8 you might even think of :
insert into ... select ... from ...
Cetin