Now it gets better.
DISP STRU does show the column as char(50)
But in the view designer -> View Field Properties it shows char(20)
Might be a documented issue somewhere in the KB.
If DISP STRU shows char(50) I guess I can live with that.
BTW this is Vfp6, perhaps Vfp7 doesn't do it.
Thanks
>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.
R. Davila
DBA / Network Administrator
Administracion de Fomento Comercial
Gobierno de Puerto Rico
Still waiting for FoxPro for LINUX