Search results

One option is to use Excel and COM-HANDLES, and attached is a procedure that will create a chart from the Sports2000 database. It is a very old procedure but it does seem to work fine with the latest versions of Excel.

I do not use SmartObjects so cannot help with an example but have a look in the PDFs listed here to see if they have any examples: https://community.progress.com/s/article/How-to-start-a-GUI-in-ADM2-that-waits-for-user-interaction Although old, there may be some examples here - as per the...

If you are on a later version of Progress you may be able to use .NET to solve: https://community.progress.com/s/article/How-to-get-printer-status-with-ABL-on-Windows

As Rob says, there could potentially be many different answers. This gives a bit of information about DBTool padding that may help: https://community.progress.com/s/article/How-dbtool-padding-affects-the-new-SQL-WIDTH-value Also this for extent fields padding...

To only apply for table 61 you need to enter 61 not all for <table> It has been quite a few years since I used DBTool to adjust padding but the last time I did I recorded the screen and if any help have listed: DATABASE TOOLS MENU - 10.2B...

Because DISPLAY ONE is appearing in the REPEAT block and straight after you create the temp-table it will display the current temp-table created thus you see all the temp-table records and numbers being created from 1 to 174. For DISPLAY TWO it is not in any block and is just displaying a...

Firstly, the row display trigger is the wrong place to hide and view browse columns so needs to be applied in a separate place. Secondly, to hide or view a browse column you use the VISIBLE attribute. This article hopefully will help: https://community.progress.com/s/article/P167681

Unfortunately I have never done anything that requires SSL so unable to really help. Can you use OpenEdge.Net.HTTP, and if so is the "sslVerifyHost(NO)" option a solution?: https://community.progress.com/s/article/Error-9318-when-connecting-with-SSL-certificate-without-a-common

I do not think this is possible in 4GL: https://community.progress.com/s/article/Assigning-ABL-method-procedure-to-NET-callback-fails

I have rarely had to access data via ODBC or SQL so do not know the cause, but wonder if the date for that particular record is being stored incorrectly. Are you able to read records using ABL code and if so and the value is an invalid date value can you correct the value? If not, does using...

As Tom points out, DBTOOL is just giving information of the problem table and fields not the actual RECIDs of records that are the cause of the error. One idea is you could adapt the code in this article to list RECIDs/ROWIDs/key index fields so you know the specific records...

Applying FORWARD-ONLY before you open the query may help a little as it makes the query behave similar to a FOR EACH. https://docs.progress.com/bundle/abl-reference/page/FORWARD-ONLY-attribute.html QUERY cust:FORWARD-ONLY = TRUE.

That is odd. I am also currently using 11.7 and tried a few different .p's and .w's and always works. Cannot explain this.

As Cringer points out this works as expected and the attached images show this: PDSTest1.png - Variables defined for the whole procedure and the internal procedure are listed. PDSTest2.pmg - Only variables defined for the internal procedure are listed because they have the same names as the...

Is something like this similar to what you are looking for?: DEFINE VARIABLE cOption AS CHARACTER NO-UNDO. DEFINE TEMP-TABLE ttCustomers NO-UNDO FIELD iCustNum AS INTEGER LABEL "Cust #" FORMAT ">>9" FIELD cCustName AS CHARACTER LABEL "Cust Name" FORMAT "X(20)" FIELD cOptions AS CHAR...

Never used a smart browser so unfortunately do not know. It seems a similar question has been asked before but unfortunately no code example was given: https://community-archive.progress.com/forums/00026/08303.html Are you able to work it out from the code examples in these postings...

Is the browse a smart browse and if so then unfortunately I do not know as not used smart objects? For a standard browse you can access a selected row using something like this: IF Brws:NUM-ITERATIONS <> 0 THEN Brws:SELECT-FOCUSED-ROW().

Is the button in a completely different procedure to the browse and thus does not know anything about the browse? So you cannot do something like this to see if a row is selected in the button trigger?: message browse brws:focused-row browse brws:num-selected-rows view-as alert-box. If this...

The "Making Good Progress" book could be this one - by John Campbell not John Sadd - although may be difficult to get now: https://www.amazon.com/Making-Progress-Application-Development-Process/dp/1883451124 For the version 9 book it may be part of the downloads from the OpenEdge 9 section...

For the trigger or limiting records you can do something like this: DEFINE VARIABLE hBrowseQuery AS HANDLE NO-UNDO. DEFINE VARIABLE vQueryString AS CHARACTER NO-UNDO. hBrowseQuery = BROWSE BRW-Sector:QUERY. ON triggerChange DO: vQueryString = "FOR EACH tt-load". IF whatever THEN...