Is the view only used in this report? Could you just replace it with a cursor built using the same SQL?
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 03:59 PM, Jon Westcot wrote: > Hi Vincent: > > I tried that, but no such luck. This is really getting frustrating. I > wish I understood why this refuses to work any longer. I've changed fields > in this table before and haven't had any problems like this. > > Any other suggestions? > > Jon > > > ----- Original Message ----- > From: Vincent Teachout > To: [email protected] > Sent: Friday, January 14, 2011 1:17 PM > Subject: Re: Problem with VFP6 View that has stopped working > > > Since you've recreated the view, and it works, I'd try deleting the view > from the report DE, and then adding it back in. IIRC, I've had to do > that a few times in the past. > > [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.

