>>And, what if I am moving variables into fields and fields into variables... Its a lot more convienant to call the variable the same as the field.
>
>Really? It gives both you and VFP more of an opportunity to go wrong, especialy since varables and fields have very different scopes.
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.
When you are moving data around, do you variables (according to the standards) and then hand assign the values to them?
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?
--Todd Sherman
-Wake Up! Smell the Coffee!