>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.
It's important that you've found
where to turn it on.