Hi David,
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.
Thanks in advance for your help.
>Raul,
>
>How are you creating the view? in the view designer or with a CREATE SQL VIEW command? What is your setting for UseMemoSize?
>
>
>>I have a remote view based on a SQL Server table.
>>One of the fields is of type varchar 50 and I want to map it to char(50) in the remote view.
>>
>>The problem is Vfp keeps resetting the width to char(20).
>>If I set it to less than 20, it works but anything over 20 VFP rolls it back to 20.
>>
>>I tried deleting the view and recreating it, but still the same.
>>
>>This is happening to ALL my views where a field is based on a SQL varchar type on the base tables.
>>
>>I want to know if it can be done, before I map all of them to Memo fields.
R. Davila
DBA / Network Administrator
Administracion de Fomento Comercial
Gobierno de Puerto Rico
Still waiting for FoxPro for LINUX