1,346 questions
Advice
1
vote
2
replies
59
views
Progress ABL - Creating a multi-line text box with an Editor widget
I have a collection of long comments fields that I would like to display in consecutive editor widgets, with controlled space between them, and no need for scrollbars. In other words, I need to be ...
1
vote
3
answers
216
views
Secure Socket Layer (SSL) failure - error code 0: Unknown SSL error (9318) on HTTP GET Request
This is my first time using any kind of HTTP request in OpenEdge ABL, so I am pretty confused with the error message.
I have the following code:
using OpenEdge.Net.HTTP.*.
using OpenEdge.Net.URI.
...
0
votes
1
answer
66
views
OpenEdge Replication - Time to Replicate? [closed]
For the last couple days, I've been monting a structure to apply replication across 3 databases (Will be more than 20 in the next couple months).
The replication process is OK, both databases (Source ...
0
votes
1
answer
82
views
Freeform query - How to get clicked column index?
I'm currently creating a report program with a freeform query.
Some users requested about the possibility of sorting by any of these columns. This part itself is done, and it´s working.
My question is:...
0
votes
1
answer
34
views
Progress compile option 'requireReturnValues' fails with error throwing
I have set the compile option requireReturnValues="Error".
I tried to compile the following example code but it doesn't pass the option:
METHOD PUBLIC LOGICAL checkValue(i_cValue AS CHAR):
...
0
votes
1
answer
60
views
PCTCompile and strict compile options
Im trying to make PCTCompile fail compilation with the following settings:
requireFullNames="true"
requireFieldQualifiers="true"
requireReturnValues="true"
However, ...
0
votes
0
answers
67
views
adm2 dynfilter.w will not allow me to filter back to all records on a logical if a true/false value was filtered
I am not an expert on smart objects and yet I have inherited a few windows that contain such and at the moment I have been asked to add a filter option on a logical field. Which I was able to achieve....
1
vote
1
answer
94
views
Get All TempTables in Class
I'm using Progress 12.8 to create a custom class that will work as an object to communicate our system into some APIs for another web system.
The program itself is already working, but now I'm doing ...
0
votes
1
answer
158
views
Basic REST GET in Progress OpenEdge
I am suffering to create a single REST GET API in the Progress OpenEdge. Someone have a simple example?
DEFINE VARIABLE cResponse AS LONGCHAR NO-UNDO.
DEFINE VARIABLE cJson AS LONGCHAR NO-UNDO.
DEFINE ...
0
votes
1
answer
195
views
How to monitor memory usage? - Progress 4GL
I have defined 5 temp-tables with multiple indexes (Necessary). Each time I execute a program; a proper cleanup is happening before and after the completion of the program. On running the program, I ...
0
votes
0
answers
53
views
Quick way to test if LDAP is correct?
In my company we use LDAP in order to use SSO (Single-Sign-On) to access our ERP software.
We have realized that that are multiple users with invalid LDAP, and they are therefore unable to use SSO ...
0
votes
2
answers
182
views
Appserver for 32bit in OpenEdge 12.8
I have a 32-bit GUI on-premises application currently running on OpenEdge 11.7 that uses AppServer. I am planning to upgrade to OpenEdge 12.8 (32-bit) but have noticed that PASOE is only available in ...
0
votes
1
answer
185
views
Migrating from Progress v11.xx to v12.xx and still supporting 32 ocx's
We are trying to migrate off of Progress V11 to V12 before the spring when v11 will no longer be supported. Currently our application relies on several 32bit ocx's, and we have been told by Progress ...
0
votes
1
answer
125
views
OE11.7 to OE12.8 - Field name was not found on table
After migrating from Progress 11.7 to Progress 12.8, I started having some problems while opening some .W files on App Builder.
This only occurs to a few programs, in multiple databases, with ...
-1
votes
4
answers
152
views
File not getting delete through code flow in Progress4GL
If i run OS-DELETE using the same procedure editor it deletes but if i run through application it copies the file but the delete is not happening.
Code below:
WHEN "Processed" THEN
DO:
...
1
vote
1
answer
654
views
Progress 4GL: Problems with SSL when performing HTTP request
I am trying to use OpenEdge.Net.pl for making a call over https, and I am getting the next error message:
Secure Socket Layer (SSL) failure. Error code 17424: SSL routines (9318)
I've been reading ...
0
votes
2
answers
482
views
How to read a data value from a nested json "file" using Progress 4GL
I have the following JSON structure stored in a file, and I would like to read it dynamically and assign the values to a temp-table:
json
{
"Reprint": {
"RequestID": &...
-1
votes
1
answer
92
views
how to add hyperlinks in a pdf using openedge
I need to know if there is a way to add a hyperlink to a PDF using the OpenEdge PDF include libraries
I couldn't find anything on the internet about this topic, if anyone has an example they can show ...
1
vote
2
answers
257
views
How do i get progress database to use a specific index?
I'm trying to improve an query in progress, to do so, I've designed a specific index that should fasten response time.
How can I configure progress to use it ?
Thank you for your help.
0
votes
0
answers
188
views
Unable to connect to Progress AdminServer
The broker has suddenly stopped communicating between linux server and windows server after a recent linux suse upgrade. It looks like its not even searching the broker(Searching broker never comes ...
1
vote
1
answer
86
views
** <file-name> already exists with <field/value...>. (132) with different records
I get the Error 132 when i try to load data to my DB.
The entries with error's are like "abcß" and "abcss" or "e" and "é".
It looks like Progress handles "...
1
vote
1
answer
210
views
calling a dll using Progress 4gl
I am needing to use a dll to obtain data from a webservice. I was given sample code from our VB.net group on how they make the call. I need direction in how to do the exact same thing within Progress....
0
votes
3
answers
357
views
passing parameter to a progress 4gl file using prowin32
I am trying to pass multiple input parameters using prowin32 . But i am not able to find out the correct way of passing multiple parameters.
This is the code of my *.p file
define input parameter ...
0
votes
1
answer
55
views
DevExpress in Openedge - Column can't be edited despite enabling it
I've got a temp table full of data that I'm trying to display as a gridView with one column meant to be editable for changing a budget and is in a numeric format to 2 decimal places. It adds each ...
1
vote
0
answers
45
views
PROGRESS 4GL - How to read JSON file and store it into temp table? [duplicate]
I am new to progress 4GL and want to know how to write a query which parse below json file and store it into temp table.
{
"sdion": "VSSDG",
"Count": 1,
"...
-1
votes
2
answers
193
views
Incompatible data types in expression or assignment
I am going to write an API on progress site (ABL), but when I try to compile it, I get this error:
Incompatible data types in expression or assignment. (223)
Could not understand line 77. (196)
and ...
1
vote
2
answers
150
views
How do I fix a schema error in a metaschema table _Field? Column _Format in table PUB._Field has value exceeding its max length or precision."
I'm working with a Progress 9.1E database application. (Yes, I'm aware of how bad that sounds).
My problem began when I ran SELECT * FROM SYSPROGRESS.SYSCOLUMNS_FULL, ...which gave me this error:
...
0
votes
2
answers
291
views
Make a post with a certificate Progress OpenEdge
I'm using V-11.7 and I have no problems using HttpClient in differents scenarios, GET, POST, uploading files, getting the responses, etc. But now I have to upload an XML to an public admnistracion URL'...
-2
votes
2
answers
91
views
PROGRESS 4GL - Is it possible to check table fields affecting during assignment?
I have a custom table which has no trigger events for write. I could sense some of the data often modified from particular fields but not sure what is the exact fields in table. Is there way to track ...
0
votes
1
answer
112
views
Integration of Sendgrd API in progress 4gl for email functionality
I'm trying to integrate the SendGrid API for email functionality in Progress 4Gl, and I written piece code, but it's not working. Can anyone help me with fixing these or any suggestions?
DEFINE ...
0
votes
1
answer
643
views
Add JsonArray in an OpenEdge JsonObject,Progress-4GL
I am trying to recreate this JSON but in my code the array leaves it out of the JSON object. I have not seen it in the documentation of how to keep it inside. This is my code in it's current state and ...
0
votes
1
answer
462
views
Difference between progress 12.2 and 12.8 for the learning path
I've recently installed the trial version of progress OpenEdge 12.8 (I'm completely new to progress) and I'm going through the Basic OpenEdge Developer Learning Path and Certification Exam.
I've ...
-1
votes
1
answer
138
views
Progress 4GL - SYSTEM ERROR: Index oid_sd_det in tt_temp for recid 3747514 partition 0 could not be deleted. (17630)
I am getting below error after dump and load data from a table(int32) to the same table(int64) and run the program. Any Idea how to solve this?
SYSTEM ERROR: Index oid_sd_det in tt_temp for recid ...
0
votes
0
answers
92
views
Compiler choose primary unique index - PROGRESS 4GL
From below query I have given all the components for index vdmod_idx1. But when I checked XREF, I can see the compiler choose vdlist since it is primary unique. May I know why it is behaving like this....
1
vote
2
answers
187
views
Apply changes in a sub transaction in Progress
I'm trying to apply changes and release the changed tables in a sub transaction but not yet in the main transaction.
Like so:
MAIN_TRANSACT:
DO TRANSACTION:
// do stuff
SUB_TRANSACT:
...
1
vote
2
answers
142
views
Wrap Powershell in Progress class
I'm trying to implement a class wrapper around Powershell.
It almost works, except that it hangs when it cannot read any more output from the STREAM.
So it manages to read all output, but after theres ...
-1
votes
1
answer
73
views
Can a table which has larger record gets often hitting in for each loop cause performance issue? - PROGRESS 4GL
I have a below simple query which causes a performance issue. a table xxdata has huge records and it's getting often hits based on total records available in table xxfin.(i.e Available records 1000 in ...
1
vote
2
answers
205
views
Multiple indexes found in XREF for one table - PROGRESS 4GL
From below query, a table tdfmstr uses two indexes and conditions added (All conditions are mandatory). After the compilation, I checked XREF of the query. I could see compiler chose 2 indexes opvdor ...
-1
votes
2
answers
557
views
What is the use of FIELDS and how its differs from table field INDEX? - PROGRESS 4GL
I understand FIELDS option allows you to explicitly specify the fields we want to work with, which can be useful for optimizing performance and reducing unnecessary processing. It's particularly handy ...
1
vote
1
answer
103
views
How do I know my query used index for the table I used?
I use a query below to check data in temp table. Also defined an index. I could sense that after adding the index to the temp table, the query gives the result asap. I would like to know how the index ...
0
votes
2
answers
570
views
How to trim Progress Application Server agents?
Before, when I was using Classic Appserver, running the command
asbman -i <appserver> -trim
would simply trim the agents, but after switching to PAS, I can't seem to trim the PAS agents.
Is ...
0
votes
1
answer
606
views
How to retrieve a data value from a nested json file using Progress 4GL
How to get the value of Example: "JournalNum" from the below json Object
{"parameters":{"ds":{"GLJrnHed":[{"Company":"EPIC06"}]}}
My code ...
0
votes
2
answers
90
views
How xml-node-type = 'hidden' play a role in a loop
I am writing progress 4GL code that builds an XML address tag based on multiple qualifiers like supplier, buyer, issuer of invoice, and delivery party using one temp-table tt_address.
for every ...
-1
votes
3
answers
168
views
How to export the start date and time in MS Project?
I am working with Progress 4gl(11.7) version where I came across a scenario where We are doing Job/task export from application to MS project. Everything is working fine but we have a problem in ...
0
votes
1
answer
248
views
Copy and use Progress database file at runtime
I want to create a copy database in file format from the one I'm already connected to.
After creating it, I want to immediately do stuff with it (populate it, run queries etc).
Is this possible?
...
0
votes
2
answers
132
views
Is it possible to find out the list of programs which reads a table per second in real time? - PROGRESS 4GL
In production, with the help of some monitor programs, we could see a particular table got read 120k times (OS Read) per second. I wonder how is this possible and looking for a program which gives ...
0
votes
2
answers
393
views
Using preprocessor variable as include file parameter in Progress
I'm trying to use SCOPED-DEFINE or GLOBAL-DEFINE preprocessor variable as named input parameter to my .i file.
myprocedure.p:
&GLOBAL-DEFINE MYDATATYPE INTEGER
{myinclude.i &DATATYPE={&...
0
votes
2
answers
669
views
CREATE trigger in an OpenEdge database
We have the following situation:
Our primary database is an OpenEdge one, and we have a SQL database which we have to sync up with our OE one. We came up with a plan to set up staging tables for our ...
0
votes
1
answer
2k
views
OpenEdge ABL JSON to temp table: READ-JSON
How can I READ-JSON this (below) into temp table :
{
"args": {
},
"data": "{\"name\":\"morpheus11\",\"job\":\"leader1221\"}",...
0
votes
2
answers
176
views
Get invoked Progress procedure .p file location at runtime
Lets say I have a simple procedure file in my system:
C:\git\project\helloworld.p
Inside this procedure file, the code needs to know it's location on my system at runtime. So in my computer in this ...