ABL(4GL) General Programming Group

This group is for topics on coding in ABL (formerly known as Progress 4GL). Topics include code snippets, code examples, utility programs, tricks, techniques, and patterns. There are other groups for other more specific topics like Win32 API, OO programming, and specific programming tools.


MS WORD ReadOnly Method

Hi,
My application creates an invoice in MSWORD and then subsequently email's the document. I want to make the document 'Read Only' before the it gets sent off. Does anybody know the syntax to achieve this?

Thanks in advance.

Errol


Haversine implementation in ABL

This is the Haversine formula translated into an ABL procedure. The Haversine formula is used for determining the Great-Circle distance in km between two latitude/longitude references.

The formula is based off the Javascript interpretation here: http://www.codecodex.com/wiki/Calculate_Distance_Between_Two_Points_on_a...

Requires Progress STandard Libraries with math_asin function uncommented (see http://www.oehive.org/node/2057)


slibmath.p Functions commented out

A large portion of this file is commented out, including the math_atan function which I wanted!
I have uncommented it, and commented out just the math_sin, math_cos and math_tan functions (already defined).
Is there a reason for this?

(BTW really appreciate this library!)


To add scroll bar to one column in a query based browser

Hi,

I am relatively new to progress.
I have a requirement wherein I need to add a scroll bar to a single column (last column) in a query based browser.
Query based browser: qweQuery based browser: qwe


Query based browser

Query based browser

qwe


Updating multiple tables

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


New Version of base64encode.p

Dries Feys was good enough to send out a new base64encode.p file over the peg. I am posting it here for further distribution (and use!)

(Note: Some have said they have had problems with this.)


Convert .NET System.Byte[] TO Progress MEMPTR

I would like to convert .NET System.Byte[] TO ABL MEMPTR (BLOB).
What is the most efficient way to achieve this?

I have already create code to get this done, but it performs much to slow. (see code snippet: METHODE 1)

I was try to increase the performance for the conversion by using base64 as an intermediate form.
But i can not get it to work. See code snippets METHODE 2 and METHODE 3)


/* METHOD 1 */
METHOD PUBLIC STATIC MEMPTR ConvertToMemptr( byteArray AS "System.Byte[]" ):


Excel page orientation

Hi all,

I am expecting help for this. Working on web-based application. webspeed, agent, broker, ps:eScript bla bla bla...

Now will come to the problem. Excel oops.. is the problem now..

We can create excel sheet and can do the formatting using Progress code. No problem with this one.


progress explorer tool (server 2008)

I use 10.1C on server windows 2008. i get error when i try to start progress explorer tool.
anyone , can help?

regard,
G


progress explorer tool (server 2008)

I use 10.1C on server windows 2008. i get error when i try to start progress explorer tool.
anyone , can help?

regard,
G


progress explorer tool problem with server 2008

Hello Ryno, thanks for your help,
I use 10.1C on server windows 2008. i get error when i try to start progress explorer tool.
the Adminservice runing without any problems.

thanks
Goran

I try sends few days, to find some solution for the problem with windows 2008.
the progress explorer tool, cant not be start on 2008 server .
I find something online, but it don’ts works. Did you have maybe some other solution? (Script, exe ,or something else)
(
Windows Registry Editor Version 5.00
[HKEY_CURRENT_USER\Software\Microsoft\Java VM]
“EnableLogging”=hex:00,00,00,00


Generation of XML files in UTF-8 format

Hi,

I'm trying to generate XML files in UTF-8 format using progress. The purpose of this is to display hebrew characters.
The current code page is "ISO8859-1". The only codepages which have collation to hebrew seem to be "ISO8859-8" and "IBM862".
Is there any way to convert codepage from "ISO8859-1" to either "ISO8859-8" or "IBM862"? Or is a code page conversion from "ISO8859-1" to "UTF-8" sufficient?
Please advise.

Thanks.


Integrating Adobe CQ5 With progress

Hi All,

We are looking a way to integrate CQ5 with existing progress webspeed app. Anybody knows ongoing project on this two technologies ???


Voleso HTML Templating Tool Open Sourced

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.


#
Syndicate content