Thanks, Sergey

I rely on the VFP View designer so little. As you say, third party tools like Rick Schummer's View Editor Professional ( white light Computing ) or Dan Goodwin's VFEGenview ( which integrates into VFE like it's part of the framework ) have become standard for me. But I had forgotten you could change the data type within the view designer in View Code and that does the trick. Good one to remember as we move to SQL 2005 and take advantage of the new data types.

Thanks again


>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