Hi everyone,

I had extended weekend and was only able to fiddle with this again until today. Boy do I feel stupid for wasting everyone's time on this so-called mystery. I have been modifying a ton of fox 2.6 code lately and then using the modified code to perform the data conversions.

This fox code is fairly convoluted, has been edited by countless programmers before me, and is over 12 years old. There are a lot of the scatter/append blanks/gather methods for creating records, as well as a few lines with macro expansion such as "INSERT INTO &m.Outfile from memvar" or sometimes insert into (m.lcOutfile) FROM memvar". When I ran the code with the Insert into (m.Outfile) in VFP6 and it ran so fast, and yet so slow in VFP9, I was so sure that I had found a bug in VFP9, that I totally ignored the fact that I should be using the TABLE'S ALIAS rather than a Name Expression on the insert line in the first place!!!! As soon as I changed that, VFP9 performed the 10k operation in 1/2 second.

So, forget I posted all of this, and sorry for the tangent I put you on. :-{
We had fun though right? .....it was a hoot.... or maybe not and simply a good learning experience for Yours Truly.

Thanks everyone for humoring me.

-Rick