The ; is old xBase shorthand for a linefeed, iirc. Happy B-day!
-- rk -----Original Message----- From: ProfoxTech [mailto:[email protected]] On Behalf Of Jeff Johnson Sent: Friday, August 16, 2013 10:19 AM Subject: Re: FRX2ANY Freezing - Problem Solved The first was a syntax error that frx2any picked up but the standard report writer allowed it. So it was not initiating because of the syntax error. Here is the value that was being printed in one of the report fields: customer.name; customer.address; customer.city + ',' + customer.zip which the report writer allowed customer.name + chr(13) + customer.address + chr(13) + customer.city + ',' + customer.zip cleared the syntax error It still hung up and here is what I found: They have a report form procedure that calls REPORT FORM &prform TO PRINTER PROMPT PREVIEW. They call this procedure with "MYREPORT.FRX NEXT 1" IOW they call the report with the scope. Works fine but when printing to frx2any there was no scope clause because I was not aware of this fact. So frx2any was hanging because it was creating a PDF for about 300,000 records. I set the scope to the current record and it worked fine. Today is my birthday, so this solution was my birthday present to myself! May all of your challenges be as exciting. Jeff _______________________________________________ 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/DF1EEF11E586A64FB54A97F22A8BD044228A7448A7@ACKBWDDQH1.artfact.local ** 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.
