This is usually caused by a TRIM() function used in the SELECT part of the SQL. What happens is the field width of the TRIMmed field is based on the first record retrieved. The next time, the TRIMmed width may be different.

If you are trimming, I suggest you also use PADR to fix the width of the field.

>Hi there.
>
>I just rebuilt one of my pc's (a notebook) over the last 24 hours ... and all is running ok in VFP ... EXCEPT ...
>
>Now, if I try to use a filter expression in a remote view of a MS SQL table that uses LIKE and a parameter field ... I get ....
>
>"Base table fields have been changed and no longer match view fields. View field properties cannot be set."
>
>This happens as soon as I try to save the remote view.
>
>eg filter exp; Person.Lastname like ?srchname
>
>...the thing is, its a brand new remote view .. I have tried a new database container, and new project ... reinstalled mdac2.6 .. reinstalled service pack 5 ... re-installed VFP and then service pack 5 ... no luck.
>
>The base tables haven't changed and as I said, it happens with any remote view where I try to filter using like and a parameter field.
>
>I've seen the problem where the base tables and the remote view actually DON'T match and I know how to fix this ... but this is not that!
>
>Does anyone know what might be broken?
>
>Ack!!! ... don't want to plow the whole op sys under yet again and start over!!!
>
>Please help!
>
>Thx, Scott :-(