Raul,
Ok the fact that your updates commit more columns leads me to the question about why you think they are char(20) columns. Do this:
select 0
use TheView
disp stru
what column widths is it showing?
>In the view designer. They are very simple views.
>Usually if the views are complex I create them in the designer and then "tweak" them in code, but these are very simple.
>
>UseMemoSize is at default -> 255
>
>Now that you mention CREATE SQL VIEW, I haven't tried changing the field properties programmatically.
>
>An odd thing is that, even though VFP sets the field to char(20), I can still enter more characters in the field and it updates perfectly against the base table in the SQL Server. But I don't want to rely on that behavior now to find out later, in production, that it is truncating.