The OpenEdge Hive

I'm trying to update 3 fields in 2 tables based on the following, but I'm getting a syntax error.
Error: Syntax error (7587) (State:37000, Native Code: FFFFB1DD)

What's wrong with this statement?

update pub.poheader, pub.podetail, pub.porel
set openorder = 0, openline = 0, openrelease = 0
where ph.PONum = pd.PONum
and pd.PONum = pr.PONum
and pr.poline = pd.poline
and ph.openorder = 1
and pd.openline = 1
and pr.openrelease = 1
and ph.orderdate < '2011-01-01'

jim_chance@yahoo.com

The .jpg on the website looks huge!!! I am going to try and attach the .tif (prior to Irfanview conversion to see if it looks blown up too.

Attaching "a small simple .p to reproduce the problem? (like pdf_new, add the image and pdf_close)".

We are using Irfanview to convert .tif to .jpg and then using PDFinclude to insert the .jpg(s) into a .pdf. We started getting an out of memory error with Irfanview so we downloaded the most recent version of that software (running 2009 now instead of 2003). This eliminated the Irfanview error but now the .pdf file we are creating via Progress is showing a "ghost" image of each .jpg three times on the same page (size is greatly reduced) and throwing the Adobe error "Insufficient data for an image". Any help is appreciated.

I've been using PDF include for many years but have recently tried to deploy it running under an appServer agent. I've isolated the problem to the pdf_load_external procedure. A symptom of the problem is that when this code is run:

/* If we can put the data into a Character Field then do so.
Then change any Xobject references within the external file. This is
due to duplication of Object names when using multiple external PDF
files */

ASSIGN iFileSize = GET-SIZE(mFile)
iPointer = 1
iMemSize = 10000.

The first time one needs to rework the HTML for look and feel in an application, one quickly learns about the need for separating the HTML from the application code. HTML Mapping was an attempt at this, however, there is still the need for a Progress Development License as well re-compiling on changed code.

Other languages have encountered this need – PHP with the Smarty template processor as well the various one's used in the C and C++ world. These processors do not require re-compiling and allow for HTML designers to work outside of the application code environment.

Just uploaded a new version of the OpenXML Libraries and tutorial.

Recent updates -

- Added support for resizable images.

- Added support for external, linked images.

- Added numeric and date internationalization features.

- Bug fixes and performance improvements.

You're invited to download the tools and try the samples or just look through the tutorial.

http://www.oehive.org/project/libooxml

If you have any questions please feel free to contact me.

Alon Blich
Email: alonblich@gmail.com
Phone: +972-54-2188086
Skype: alon.blich

Just uploaded the first version of the OpenXML Libraries tutorial.

http://www.oehive.org/project/libooxml

Please download and read the tutorial.

I'm sure you'll find a few tricks you didn't know about.

Keep checking the project page.

More updates are planned to be released soon including a Free Lite version.

Every once in a while a question comes up in the Progress forums ...

I can't find the sin, cos, tan functions ?

I'm happy to say this question has finally been resolved

thanks to Jeff Pilant who donated the sin, cos, tan functions

to the Progress STandard Libraries (STL) open source project.

http://www.oehive.org/project/lib

/* test-slibmath.p */

{slib/slibmath.i}



define var iDegree as int no-undo.

repeat iDegree = 0 to 360 by 5:

    display
        iDegree                             format ">>9"                column-label "Degree"
  

I've uploaded UNIX/Linux r-code versions for the Word and Excel utils express edition.

Please download the utilities and try the samples.

http://www.oehive.org/project/libooxml

If you have any questions or requests please feel free to contact me.

Alon Blich
Email: alonblich@gmail.com
Phone: +972-54-2188086
Skype: alon.blich