Thanks for all your effort. I found the problem. If I convert the decimal columns in the VFP table to type double, the above code works.

Thanks but that gives me an error pointing to the last dirmsarf2:

Incorrect syntax near 'dirmsarf2'.

I tried your code and it gave an error on the 'dirmsarf2' at the end. I took it off and it gave an error on the last closing ')'