On Thu, 18 Jun 2015 14:19:45 -0400, "Tracy Pearson" <[email protected]> wrote:
>Hello, > >It was brought to my attention today when someone > adds a new field to a report > uses the Expression Builder to select two fields separated by a + symbol > click OK and OK > the ReportBuilder throws an error > >This is from the VFP 9 SP 1 ReportBuilder.app >--------------------------- >Report Builder Error >--------------------------- >Alias is not found. >Line 0 in saveexprwidth(): >DO (_REPORTBUILDER) WITH __ReportReturn, 2, __ReportCCObject, 1 > > >fieldexprhandler.Error() > >Do you want to suspend execution? >--------------------------- >Yes No Cancel >--------------------------- > >I attempted to see if it was on http://vfpx.codeplex.com and the server is >not responding. > >So I found the xSource for VFP 9 SP 2 on the Microsoft site. Tracked the >saveexprwidth method in the class panelfieldexpr, in the class library >frxpanels. > >Adding the following to the end of line 71 corrects the problem: > and used( m.cAlias ) > > >Say the expression is "alias.firstfield + alias.secondfield" >m.cField contains "secondfield" >m.cAlias contains "alias.firstfield + alias" > > >HTH, >Tracy Hi Tracy, I have the XSource for Visual FoxPro 9.0 SP2 files from this link: XSource for Visual FoxPro 9.0 SP2 https://www.microsoft.com/en-us/download/details.aspx?id=2309 and the XSource for Visual FoxPro 9.0 SP1 files from this link: XSource for Visual FoxPro 9.0 SP1 https://www.microsoft.com/en-us/download/details.aspx?id=14134 But in the SP1 version at line 71 your correction is already implemented. And in the SP2 version the code is more accurate in checking m.cExpression and your case is managed as well. Gianni _______________________________________________ Post Messages to: [email protected] Subscription Maintenance: http://mail.leafe.com/mailman/listinfo/profox OT-free version of this list: http://mail.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.
