Hi,
Sorry I took so long answering. I took a small birthdate vacation. ;)
disp stru does show the width I entered on the Field Properties dialog.
Also DBGETPROP('MyTable.MyField', 'Field', 'DataType') shows the correct information. for example C(55).
But again if I do a MODIFY DATA -> right click on view and choose modify -> click on Properties -> the "View Field Properties" dialog shows C(20).
I think this is simply a bug in the View Designer, which IMHO has never been very good anyway, perhaps it got better in VFP7.
BTW - I have SP5 installed.
>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