Hi Charles,

Looks like View Designer incorrecly sets DataType propery of the view field mapped to SQL varchar(max) as V(0). You can open View SQL window and change it to 'M'. You can also try third party view designers (free or commercial).

>I am getting problem validating views against SQL2005 databases with VARCHAR(MAX) fields. I'm really very surprised that vfp9 wouldn't recognize varchar(max) and even more surprised I've never noticed this behavior before. I'm allow that I may be doing something else stupid but I tried a very simple test
>
>create sql table - pk, cfield1 (char(10), mnotes (varchar(max), timestamp (timestamp)
>
>create a remote view update keyfield and timestamp.
>
>Boom!
>
>Is this known behavior and is there a workaround ( besides changing all my varchar(max) fields to text? )
>
>TIA