Hi,
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.

Any ideas?
Thanks