Search results

You also need to delete the dynamic temp-tables as well. You may find this article useful: https://knowledgebase.progress.com/articles/Article/P124514

My previous posting missed including this article which again is a straight copy: https://knowledgebase.progress.com/articles/Article/How-to-copy-the-data-of-a-database-to-another-database-having-the-same-schema

I thought that a posting/article existed that showed how to do this with dynamic queries but can only find one that does a copy: DEF VAR tablename as CHAR INITIAL "table1,table2,table3" /* and so on */ DEF VAR cTraverseOldTable AS CHARACTER. DEF VAR iTableArrayIndex AS INT. DO iTableArrayIndex...

I do not know if this article is any help as it shows you can run a program before you run the AppBuilder: https://knowledgebase.progress.com/articles/Article/000039351

I see. I am not sure if that is documented anywhere. The manual says this which indicates it may be similar to running from the Procedure Editor: You may find answers in the AppBuilder source code: https://knowledgebase.progress.com/articles/Article/P9621

Do you want to know how to run directly from the AppBuilder or if the AppBuilder is running the program as persistent? The attached image shows how to run from the AppBuilder and what to set if you want to run as persistent or not.

To add a calculated column you do something like this: hCalcCol = myBr:ADD-CALC-COLUMN("CHAR", /* Data type */ "X(15)", /* Format */ "", /* Initial value */ "Calc Column"). /*...

As per rule 6/7 in this article slowness due to the bracketing resulting in reading all records: https://knowledgebase.progress.com/articles/Article/P7066 Try this: FOR EACH ucd_receival NO-LOCK WHERE (ucd_receival.id_location = <value> AND ucd_receival.da_receival_date = 11/19/2019) OR...

According to these articles it appears only new tables, new fields to existing tables or new indexes to existing tables can be added on-line: https://knowledgebase.progress.com/articles/Article/How-to-handle-the-loading-of-a-delta-df-when-it-is-blocked-by-a-client-accessing-the-database...

I think maybe something along these lines: objSheets = CAST(objWorkbook:Worksheets,Microsoft.Office.Interop.Excel.Worksheets). objSheet = CAST(objSheets:Item[1],Microsoft.Office.Interop.Excel.WorksheetClass). objSheet:Range["A1"]:Value2 = "Cell Value". MESSAGE objSheet:Range["A1"]:Value2 VIEW-AS...

You first need to add to Assemblies.xml: https://documentation.progress.com/output/ua/OpenEdge_latest/index.html#page/dvngp/identifying-.net-assemblies-to-abl.html It should be available to add in "Global Assemblies".

IN SUPER is used to declare that the function is found in a super procedure and that the function is implemented in the super procedure. /* main.p */ define var hdl as handle. FUNCTION TodaysDate RETURNS DATE () IN SUPER. run sub.p persistent set hdl...

I don't know if these are any help but 2 possible options: Option 1: https://helpcenter.gsx.com/hc/en-us/articles/360001520328-How-to-Check-What-Version-of-NET-Framework-4-is-Installed-on-Your-Computer DEFINE VARIABLE cRelease AS CHARACTER NO-UNDO. DEFINE VARIABLE cVersion AS CHARACTER NO-UNDO...

Normally it is: view W-Win.

It seems to suggest that your replacement that you are now running persistent does not have any code in it to view the window. Maybe myWindow did have, or the viewing of the window is being activated by the calling program thus the reason for setting a handle. Setting a handle for a persistent...

As Cringer posted, have you added to assemblies.xml? For a quick start try the following: Place the .dll files in the Progress/Project working directory - MESSAGE SESSION:TEMP-DIRECTORY VIEW-AS ALERT-BOX. As per this site - OpenEdge 11.7 Documentation - add all the .dll files via the "Local...

If Windows and version 10.2B or later then one way is using .NET controls: http://jadn.co.uk/w/ReadPdfUsingCsharp.htm https://www.e-iceblue.com/Knowledgebase/Spire.PDF/Program-Guide/How-to-Extract-Text-from-PDF-Document-with-C-/VB.NET.html Most are paid for options, but this one is free...

Using a combination of the ideas Cringer and Tom have posted you could do something like this: DEFINE BUTTON bOkay LABEL "OK" SIZE 12 BY 1. DEFINE VARIABLE vText AS CHARACTER FORMAT "X(50)" NO-UNDO. vText = res-group.resource-group + ' has an hourly maximum of ' + string(nHours) + ' hours.'...

For the compilation messages I used to have the exact same problem and nothing seemed to work. It only fixed itself when I created a new OpenEdge project. The new OpenEdge project did not create a .propath file as the other projects had, but seemed to restore the compilation messages for all...

You say you have copied the file from the Linux server but as RealHeavyDude posted the files should be in the DLC directory. For example I have the relevant library file in: C:\Progress11\OpenEdge\java\openedge.jar And selecting "Find Class' shows the driver available: Do you have Progress...