On 08/15/2013 01:04 PM, Jeff Johnson wrote:
I am running FRX2ANY and this application is not working yet. It
starts to convert and then locks. I am getting the error:
Syntax Error
pdffile
Error 10
Method InsertObject
Line 0
Any ideas what I am doing wrong. The app, dll, frx and all in the
current folder.
TIA
This one was a good one - as most of mine usually are. I am working on
an application that is featured on "How to Write Unmaintainable Code."
There were two problems.
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
---------------
Jeff Johnson
[email protected]
(623) 582-0323
www.san-dc.com
www.arelationshipmanager.com
_______________________________________________
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.
