>
>Who knows maybe I'd change the above code slightly to get all into an SQL cursor first and do a single append (no for), or create an index for recordstoProcess.myPk and drop scan again ( append .. for seek(myPk,'recordsToProcess','key') ), or copy to array, insert from array in blocks etc (last one is an exceptionaly fast method but coding generally complex)
>
>Operations like this can be done in multiple ways in VFP and I choose the strategy based on what'd I do, loop needed or not etc. Sometimes I even choose a slightly slower one for sake of readability or go writing into C dlls that directly write to table :)
>
Thanks for the ideas...I'll probably won't be using C DLLs for this :)
Steve Gibson