>Why is it that all varchar fields become memo fields when issuing a COPY TO ... TYPE FOXPLUS command? and is there a way to avoid it?
Even older versions of Visual FoxPro don't have a "Varchar" type. What would you convert it to, without losing data? The only type that supports a variable length is a Memo or Memo(Binary).
If you are sure that the varchar has no more than a certain number of characters (up to 254), you can convert the field to Character type, and then do the COPY TO.
Update: I hadn't worked with Varchar before; I now see that like character, it has a limit of 254 characters. Pressumably, Visual FoxPro uses this default conversion for compatibility: the idea of varchar is that the expression is NOT filled out with blanks, up to the maximum field length. Memo has this property, too.
Difference in opinions hath cost many millions of lives: for instance, whether flesh be bread, or bread be flesh; whether whistling be a vice or a virtue; whether it be better to kiss a post, or throw it into the fire... (from Gulliver's Travels)