This is normally due to your view being defined such that the column widths might vary depending on the data being returned.
For example, if you have something like this in your SQL: SELECT ALLTRIM(FirstName) could vary the size depending on the filter applied to the view. You should change that to something like this: SELECT PADR(ALLTRIM(FirstName), 50) Frank. Frank Cazabon Samaan Systems Ltd. - Developing Solutions www.SamaanSystems.com Referrals are important to us. If you know of anyone who would benefit from our services, please contact me. We would appreciate the opportunity to work with them. On 14/01/2011 01:59 PM, Jon Westcot wrote: > Hi all: > > I've got a problem with a view in VFP6 that has stopped working. The > error that I'm getting from the original view is: > > "Base table fields have been changed and no longer match view > fields. View field properties cannot be set." > > Oddly, I can still BROWSE the view without complaint. I just can't seem > to use it within a report. > > I've tried deleting the offending view and recreating it, but that > didn't seem to help, which I found even odder behavior than the error that I > am getting. > > Some obvious questions, with hopefully helpful answers: > > HAS the base table actually changed? Yes. Some fields have been > added to the table, and at least one field has increased in size. > > Can you browse the new view? Absolutely. Just like with the old > view. They look the same, too, when browsed. > > Can anyone shed some light on this issue? This is really getting > frustrating. I suppose that I could rework the report to eliminate the view > if I must, but that's kind of a drastic "last-step" solution (at least in my > mind). > > Thanks! > > Jon > > [excessive quoting removed by server] _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://leafe.com/mailman/listinfo/profox OT-free version of this list: http://leafe.com/mailman/listinfo/profoxtech Searchable Archive: http://leafe.com/archives/search/profox This message: http://leafe.com/archives/byMID/profox/[email protected] ** All postings, unless explicitly stated otherwise, are the opinions of the author, and do not constitute legal or medical advice. This statement is added to the messages for those lawyers who are too stupid to see the obvious.
