Questions tagged [progress-4gl]

The Progress 4GL is a multi-platform interpreted language typically used to build business applications and is now known as ABL.

With a first official commercial release in 1984, Progress 4GL was initially a procedural language and has since had object-oriented extensions added to the language starting with the OpenEdge 10.1 version. The language offers tight data binding to the Progress OpenEdge database and also runs on the OpenEdge AppServer.

The Progress 4GL is now known as the OpenEdge ABL (Advanced Business Language) and is produced by the OpenEdge division of Progress Software Corporation.

Hello World

DEFINE VARIABLE msg AS CHARACTER   NO-UNDO.
msg = "Hello World!".
MESSAGE msg VIEW-AS ALERT-BOX INFORMATION.

Useful links
Progress Software

Progress Official Developer Network

The OpenEdge Hive

Progress KnowledgeBase

Progress E-mailing list (PEG)

ProgressTalk Forums

Wikipedia
http://en.wikipedia.org/wiki/Progress_Software http://en.wikipedia.org/wiki/OpenEdge_Advanced_Business_Language

1293 questions
3
votes
3 answers

INTEGER() of a space character(s)

Does anyone know why INTEGER(" ") is zero in Progress 4GL? The result is same even if you pass empty string to INTEGER() function. What could be the theory around this? Please help I have gone through the documentation but couldn't find anything…
Austin
  • 1,237
  • 1
  • 11
  • 22
3
votes
2 answers

System.String:Format limited to 3 input in progress 4gl?

Is the function System.String:Format is limited to 3 input? When I do: DISPLAY System.String:Format("~{0~} ~{1~} ~{2~}", 0, 1, 2). Everything is fine. But when I do: DISPLAY System.String:Format("~{0~} ~{1~} ~{2~} ~{3~}", 0, 1, 2, 3). I get a…
Tom Sawyer
  • 835
  • 2
  • 10
  • 32
3
votes
1 answer

How do you setup project to use ini file in Developer Studio?

I use a ini file to setup fonts and colors (instead of the registry). I have linked the ini file like this: Properties->ProgressOpenEdge->Startup parameters-> "-basekey ini -ininame C:\somepath\ini\progress11.ini" If I make a small run file (and…
LeoD3
  • 195
  • 10
3
votes
1 answer

Finding the base file name

What the easiest way to find the base filename in progress. I have: /tmp/admin/run/test.txt and I want: test.txt 10.2b
Bill
  • 1,237
  • 4
  • 21
  • 44
3
votes
1 answer

Reading XML file to Dataset in Progress-4gl

My XML File is like this
pikk
  • 525
  • 1
  • 12
  • 26
3
votes
2 answers

PROGRESS - Validating a user-input file output path

I've written some PROGRESS code that outputs some data to a user defined file. The data itself isn't important, the output process works fine. It's basically DEFINE VARIABLE filePath. UPDATE filePath /*User types in something like…
user2961924
  • 31
  • 1
  • 2
3
votes
1 answer

progress 4gl OpenEdge abl delete file from directory

How can you delete a file from a directory using OpenEdge ABL (progress-4gl) code? I cannot find any code samples that get close to exemplifying this problem. I know how to output to value(path), and to input from value(path), but how is a delete…
Price Jones
  • 1,948
  • 1
  • 24
  • 40
3
votes
4 answers

How to round up in progress programming

I am writing a report for an MRP program and it contains a field I calculate for the quantity to order. I need to round the number up if it is a decimal point. For example: 2.33 needs to be rounded up to 3 and so on. I have tried oder =…
Jim S.
  • 203
  • 8
  • 24
3
votes
2 answers

FOR LAST - Query, giving wrong result

I'm looking to use the following query to find the last tender id. FOR EACH tender-table NO-LOCK WHERE tender-table.kco = 1 BY tender-table.id: DISPLAY tender-table.id. END. This query looks at all the tender id's and brings back all the…
Matt_Johndon
  • 204
  • 1
  • 6
  • 15
3
votes
2 answers

PyQT Qscintilla Progress 4gl

I have been messing around with creating my own Progress 4GL Editor recently by implementing QsciLexerCustom in my python application. But while browsing through the Qscintilla Source i noticed they already have a progress 4gl lexer in…
3
votes
4 answers

How can I calculate the total no of records using Progress 4GL

How can I calculate the total no. of records in a table? I want to show all table names in a DB along with the no. of records in each table
Jay
3
votes
2 answers

Fixing sql length error in progress 4gl 10.2B

I'm trying to use the openedge jdbc connector to pull data from an existing progress db but im running into column width issues. Here is the error that is holding me up. [DataDirect][OpenEdge JDBC Driver][OpenEdge] Column TabDisplayName in table…
Mike M
  • 212
  • 3
  • 11
3
votes
2 answers

Create COM-Object from own C# Dll in Progress 4GL

I'm wondering how I can create a Com-Object from my own C# DLL. I made the following Class in C#: using System; using System.Collections.Generic; using System.Linq; using System.Text; using System.Runtime.InteropServices; namespace ProgressNet { …
RaphaelH
  • 2,144
  • 2
  • 30
  • 43
3
votes
3 answers

How to clear out or delete an unnamed widget-pool containing my static class

I'm working with Progress 10.1c I have a class that contains both static and non-static methods. The class is defined with USE-WIDGET-POOL. In the destructor I say "DELETE WIDGET-POOL". I create an instance of my class, and call a method. The method…
RobertT
  • 1,213
  • 10
  • 12
3
votes
1 answer

How to mimic SELECT ... LIMIT, OFFSET in OpenEdge SQL?

It's a common thing in most SQL implementations to be able to select a "sliding window" subset of all the rows returned in a query. A common use case for this is pagination. For example, say I have a search page with 10 results on each page. For…
Abe Voelker
  • 30,124
  • 14
  • 81
  • 98