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.