Hi Jon, no problem. Glad you got it working.
I think Rick nailed the problem which was due to your view being defined as SELECT *. If you either explicitly listed the fields for the select or used SDT then you would not have had this problem. 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 18/01/2011 12:36 AM, Jon Westcot wrote: > Hi all: > > Meant to post this a while back, but got caught up in something else and > then, when I realized I hadn't replied, I felt pretty stupid! > > Anyhow, thanks to everyone who commented on my question about how to get > past the "Base table fields have been changed and no longer match view > fields" error. No matter what I did, short of recreating the report, the > view refused to "correct" itself, even after deleting it from the report > entirely. > > I cannot explain why I could still open the view inside the project. > Probably one of those questions I'll never resolve. ;) > > Anyhow, I chose instead to create a temporary cursor in the report > itself and to then relate it to a secondary support table that was required. > After a bit of twiddling, it all came out in the wash! > > Thanks again for your help and suggestions. You all are the greatest! > > Sincerely, > > 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.
