Questions tagged [openedge]

Progress OpenEdge is an application development platform from Progress Software Corporation

Progress Openedge

Progress OpenEdge is an application development platform from Progress Software Corporation (NASDAQ: PRGS). It includes but is not limited to:

Progress OpenEdge Database:
A relational database engine

Progress ABL:
Advanced Business Language. A 4GL programming language. Earlier known as Progress 4GL.

Progress AppServer:
An application server for supporting multi tier applications

Progress Pacific AppServer (PAS):
A newer replacement for the Progress AppServer. Based on Tomcat.

Progress Webspeed Transaction Server:
A part of the appserver used for creating web enabled applications.

Progress Developer Studio:
An IDE for developing Progress applications. Based on Eclipse.

Progress Mobile:
A cloud based IDE for developing mobile applications. Based on the Tiggzi IDE. Since the acquisition of Telerik this has been replaced with the Telerik Mobile platform.

Openedge BPM:
An API for providing Business Process Management automation in applications.

Progress Pacific PaaS:
A cloud based application development platform.

Questions around Progress Openedge is better tagged , , , or depending on what product is involved.

Simply tagging might be confusing since the questions are mixed up with progress-bars etc.

Other product lines in the Progress Software portfolio incudes:

Rollbase:
A cloud based rapid application development environment for webapps.

DataDirect:
Provides connectivity between the Progress environment and numerous data sources. For instance IBM DB2, Microsoft SQL Server, Oracle, Sybase and MySQL.

Control Tower:
Business Intelligence/Dashboard solution.

Corticon:
Business Rules Engine

Modulus:
A Node.js hosting platform including support for WebSockets, MongoDB and more.

Telerik
On October 2014 it was announced that Progress Software acquired Telerik Software, a Bulgarian company providing tools for platform development. If or how Teleriks product will be incorporated into OpenEdge has not yet (as of November 2014) been revealed.

Official links
Progress Software

Progress Community (Developers Network)

Progress Documentation Portal

Progress KnowledgeBase

Other useful links
The OpenEdge Hive

Progress E-mailing list (PEG)

ProgressTalk Forums

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

1417 questions
3
votes
3 answers

Using Break By for Multiple Fields

I would like to ask how to use multiple break by in a for each statement. Sample: Car Code Color Code 0001 002 0001 002 0001 001 0005 003 0005 002 0007 001 0008 001 0008 005 0008 001 My code…
noob
  • 165
  • 3
  • 18
3
votes
2 answers

Progress 4gl format string with constants

Is there a way to format a string in Progress with a specific character? An example is showing an SSN with x's for the first 6 numbers. I've attempted to use the String function, but it does not respect the letter x being sent in with the…
Stacked
  • 263
  • 1
  • 3
  • 8
3
votes
2 answers

How do you retrieve a date value from a buffer-field in Progress Openedge?

I've got a buffer which contains a mix of data, number and character fields. I am getting the displaying the values of the fields, but for some reason date fields return "?" when I try to add them to a string. I still get ? even if I do ASSIGN…
Screwtape
  • 1,337
  • 2
  • 12
  • 27
3
votes
2 answers

How to query same table twice in Progess OpenEdge Procedure?

In this example, I have two tables; Order Header (oe-hdr) and Location (location). The order header table contains two fields (sale-location-key and ship-location-key) which have an associated location name in the location table. If I were to use…
FancyPanda
  • 85
  • 1
  • 10
3
votes
3 answers

Progress if statement

I'm a progress noob, actually having problem with basic blocks. Below the issue is in my if else statement. It works fine when its just if, then, else then, but when I want to put in more than one statement into the if portion, I have to put it in…
Stephen Kennedy
  • 529
  • 5
  • 18
3
votes
3 answers

How to write data to CSV file in ABL coding

I populated a temp from a query, and the temp table looks like, ttcomp.inum ttcomp.iname ttcomp.iadd There are 5000 records in this temp table and now i wanted to write in a CSV file. I think it could be done with output stream but i don't know…
user3427690
  • 81
  • 1
  • 2
  • 5
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
4 answers

LIKE operator for Progress DB SQL

I'm trying to do something like this in Progress SQL (THIS IS NOT POSTGRES!) SELECT CASE WHEN code LIKE '%foo%' THEN 'Y' ELSE 'N' END as foo FROM bar However Progress does not support a LIKE operator. INSTR looks like it might do the job,…
Tarski
  • 5,360
  • 4
  • 38
  • 47
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
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
1 answer

Is there a clean way to read embedded SQL resource files?

To avoid creating SQL statements as strings in a class I've placed them as .sql files in the same package and read the contents to a string in the static constructor. The reason for this is the SQL is very complex due to an ERP system that the SQL…
Brett Ryan
  • 26,937
  • 30
  • 128
  • 163