4GL/ABL General Programming


Creating subtotals in Excel from ABL

After a lot of research, trial and error, and general head-banging, I've come up with the formula to add subtotals to a range in an Excel spreadsheet, but I can't for the life of me put those subtotals into more than one column.
This is the syntax for subtotals on a single column:
xlwksheet:range(vrange):subtotal(1, -4157, 4).
xlwksheet is the worksheet object.
vrange is a text string containing the range in CR:CR format.
1 causes the subtotal to occur at each change in the first column of the range.
-4157 indicates the subtotal is to be a sum.


Developing Application using Webspeed

Hi to all,

Can anybody direct me where I can browse for Webspeed tutorials? Any links?

I found some pdf files but just like an introductory.
I want to know how to use speedscript in updating records.

Thanx in Advance.


SFTP (Secure Shell File Transfer Protocol)

Does anyone know something more how about you can connect, send data,... in progress too an SFTP-server?


Trigonometric functions, SINE,COSINE,ARCSINE.

I need some trigonometrics function and 4GL don´t include any one.

Have anyone any dll to solve this? This is for the windows environment.

Thanks in advance.


Web Services Input

Hi All.
I'm trying to write a new Web Service.
It is a order contained in the body of the soap message.
How do I read the data within the soap message?
Below is a extract from the soap message.

TEST
SECRET
MSG-123

4012345500004

5412345000013

5412345000013


cursor-offset for Drop-down Combo-box

I have an application that had a combo-box in drop-down mode ( allow editting like fill-in) and use triger "ANY-KEY" for processing. I need the CURSOR-OFFSET to set the cursor position, but i get and error.

Is this a bug?, any work around perhaphs an API call ?.


Dynamic Menubar Items

Hi Guys,

I usually use OCX Treeview to display menus allowed for a user.
In my case, I am trying to create an application that has dynamic menu items available for users depending on the access given to them.

Sample of this is:
John:
Customers Entry
Official Receipts
...
..
.

Mark:
Official Receipts
General Ledger
...
..
.

I have a solution for this but needs a development tool during runtime.

If you have worked on this previously, please, I really need you advice.

Thanx so much!


IMPORT statement

I'm trying to fix an issue in Prolint, but this is a general ABL question. Here's the code:

   handlers = "":U.
   FILE-INFO:FILE-NAME = ProfileDirectory + "/handlers.d":U.
   IF FILE-INFO:FULL-PATHNAME <> ? THEN DO:
      INPUT FROM VALUE(file-info:FULL-PATHNAME).
      REPEAT:        
         IMPORT handler.                               
         /* if handler exists and supported in this Progress session, then add to list */
         IF CAN-FIND(tt_output WHERE tt_output.progname=handler) THEN 
            handlers = handlers + ",":U + handler.
      END.

AS400 Dataserver Upgrade

We are (still) using AS400 dataserver version 8.0C60 to access DB2 database on AS400
iSeries (os version V5R3). We have to apply the AS400 patch every 6 months but other than
that everything is working fine (client is the Progress application release 9.1D09 (no appserver)
on IBM AIX 4.3.3.0).

Our company is looking into upgrading our AS400 iSeries system, including os upgrade to
V5R4M5 or 6.1.

What am I hearing from Progress support for now is that only OE ODBC Dataserver 10.1C
is supporting V5R4. But our 9.1D client can not 'talk' to OE 10.1C ODBC Dataserver, and we


RESTFull

Hello everybody,
I would like to know that:

Is there an implementation of "RESTful principle" (Representational state transfer) in OpenEdge?
The ideas behind REST were formalized in Chapter 5 of Roy Fielding’s 2000 PhD dissertation
http://www.ics.uci.edu/~fielding/pubs/dissertation/rest_arch_style.htm


Syndicate content