I have a Progress database that I'm performing an ETL from. One of the tables that I'm reading from does not have a unique key on it, so I need to access the ROWID to be able to uniquely identify the row. What is the syntax for accessing the ROWID in Progress? I understand there are problems with using ROWID for row identification, bu...
There is a GUI ADM2 Progress v9 application using AppServer. It needs to give users an ability to view MS Excel files stored on the AppServer. So far it: Pulls .xls file from AppServer to a local drive. Fires up a copy of MS Excel and opens the file. The problem is that the temporary file on the local drive needs to be removed once...
I work in Progress ABL and use what we call AppServers. Application Servers, processes that can talk to a Progress database and run business logic on the on a server and then send a response back to the client. These come in 4 modes but I'm most accustomed to state-reset which is an appserver that preserves state throughout the connecti...
what is ROWID and RECID actually in progress.Can we use the RECID instead of ROWID.what is the diffrrence between them?? ...
What is the best way of implementing assertions using Progress 4GL or WebSpeed? ...
How would you prevent chunks of debugging code from accidentally leaking into production enviroment when using Progress 4GL? ...
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 ...
I have a smart window which contain some smart object.I want to know the name of all the object at run time or list of all the object at run time. ...
I have a PDF file at client and i want to send this PDF file on AppServer. How can i send this pdf file at AppServer? ...
I have a folder in c drive,whicn contain 1000 txt file,i want to get the list of all these txt file. How can i get this list? ...
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 ...
Is there any 4GL statement used for editing an ASCII files from the disk, if so how? ...
How can we change the default lock in Progress instead of Share-lock? ...
Hi, I'm working on a Progress Version 9 OpenEdge system and would like to change the database field validation. Can you tell me if this will have any knock on effects? I've been warned not to modify the database tables as this will result in the field/table checksum to be modified which then leads to problems. Will modifying the validat...
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...
Does anyone know how to connect to a Progress 9.1E database from a Mac (or even from Linux)? I can connect successfully from Windows but the JDBC driver requires that the Progress install directory and it's bin directory are in the path. It seems to be one product that is firmly under Google's radar. OpenLink has an OSX driver but it i...
I am in search for good literature to learn Progress 4GL. This is a workspace-related project, and funding for training is not available. I've tried the documentation, but it is inaccurate and pretty chaotic. I will have to do most work in the ChUI on OE 10.1B. I am aware of several books that are available on lulu.com. Which ones are...
Hi stackoverflow comunity, using a sax writer with the progress-4gl language i succeeded in creating an a xml 2003 workbook. My problem began when i wanted to add a linefeed to a cell. The normal linefeed for excel (in xml) is made using " ", this is a problem because the sax-writer converts & to &. I did find a workaround by usin...
Is there an easy way to fetch a file using an HTTP URL with Progress ABL 10.1B without external dependencies? If so, what is the most elegant way of doing so? I tried the documentation, but didn't seem to contain anything like that. ...
OK, so I've learned the hard way that string comparison works ... differently in Progress 4GL. For example, "x " and "x" seem to be the same thing, and "ß" is equal to "ss" - but "ö" is not equal to "oe". Is there any comprehensive list of what substrings are considered equal in ABL? I've checked the documentation, but wasn't able to ...