openedge

Should I learn Openedge as a C# programmer

We have an Progress OpenEdge (http://en.wikipedia.org/wiki/Progress_4GL) develop team in the company I work for. I'm the only c# developer there and really like it. So now the manager asks me to learn programming in OpenEdge. He doesn't want me to become a good OpenEdge programmer but he wants the team members to understand both worlds....

OpenEdge ODBC for Access

I cannot update the links in my access to a new ODBC driver. I believe it to be that OpenEDge 10.1C is not doing a handshake with Access. The dns will import external data into excel. The error is "error(-7748) the is no message for this error" ...

Problem connecting Reporting Services 2005 to Progress OpenEdge 10.2A Driver

Background: Progress based ERP system called QAD 2008.1 (formerly MFGPRO. SQL Server 2005 Enterprise SP2. Reporting Services 2005 SP2. Progress OpenEdge 10.2A Driver. ODBC System DSN created using the Progress OpenEdge 10.2A Driver. Problem: I am creating a report with Reporting Services and will need to use the Progress OpenEdge 10.2A ...

Progress ABL: How to have windows open in same position on the screen as they opened last time.

We currently use this logic to center every new window: ASSIGN {&WINDOW-NAME}:X = (SESSION:WIDTH-PIXELS - {&WINDOW-NAME}:WIDTH-PIXELS) / 2 {&WINDOW-NAME}:Y = (SESSION:HEIGHT-PIXELS - {&WINDOW-NAME}:HEIGHT-PIXELS) / 2. However, the user want to position the window in a certain place. When they clos...

Weird OpenEdge query behaviour

We have recently had to do some work with an OpenEdge database that a third party product uses, and today (after much hair-pulling), we finally identified why a view was returning no results. This view in question combines about 100 separate tables, and is then queried against (we have limited rights to this database). One of the fields ...

SQL Command ISNULL for ODBC Connection

I'm connected to an OpenEdge DataServer via ODBC (not our product, we are just accessing their database, I hardly have any information and certainly no help from the other side). Anyhow, I just need to execute a simple Select, add a couple of rows and I need the equivalent of an IsNull statement. Basically I'd like to execute SELECT I...

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, but it is a Progress extension an isn't supported on the DB I am using. Is there another ...

How do I do HTTP GET and POST in Progress/OpenEdge ABL?

The Progress docs spill plenty of ink on SOAP, but I'm having trouble finding the example for a simple HTTP GET/POST with Progress ABL. How do I GET and POST strings to/from a URL? Can the URL be https://? Can Progress provide HTTP Basic or HTTP Digest authentication? ...

How to get table schema from Progress database via odbc

Oh lovely Progress.. I have a linked server set up between sql 2008 and a Progress OpenEdge 10.1b server. How do I get the table schemas? ...

Delphi connection to OpenEdge Progress-4GL Database

Folks: Has anyone had success connecting to a Progress-4GL database with Delphi?   I've been unable to establish any connection with the ODBC driver provided by the vendor (Progress OpenEdge 10.1C Driver). I've entered (what I believe are) the right parameters, but keep on getting an error whenever I test the connection: "[Data...