>
>But if they are the same name, I can use insert from memvar, or use afields to go thru the list of variables as well as the list of fields if I had previously done a scatter memvar blank.

IMO, these techniques are not a good idea under VFP. It leads to more problems and makes the code much more difficult to read. I have some old 2.x code that uses SCATTER/GATHER MEMVAR all over and is almost impossible to trace through for maintenance/bug fixes. Views or SPT is the way to go.

>
>When you are moving data around, do you variables (according to the standards) and then hand assign the values to them?

The above mentioned 2.x code moves data all over the place, which is another problem with debugging/maintenance. The new design to be implemented later this year will write each value once and use a flag field to determine the state of the data. It will also be faster.

>
>I ran into trouble with sql anywhere. If I try to write a empty or null date field into a sql anywhere remote view from foxpro, I get a C5 error. So, it kinda cuts out being able to use insert from array or insert name commands... I would rather not have to go thru the 600 or so fields in the 30 or so tables by hand. Its a lot easier to just release those variables that are empty or null prior to doing insert from memvar.
>
>Is there a better way?