Search results

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...

To a degree yes, but you cannot trap the error cleanly: https://community.progress.com/s/article/000028152 DO ON STOP UNDO, LEAVE: RUN invalidprogram.p. END. MESSAGE "Program is still running." SKIP(1) "Was there an error?" ERROR-STATUS:ERROR VIEW-AS ALERT-BOX INFORMATION.

Just to be clear, you have a browse for temp table records and want to change the values of some of the columns and you have used the free form query option, is that correct? If so, then in the DISPLAY section enable the fields/columns you want to allow changes:

It appears you have successfully unblocked the three dll's and added to assemblies.xml which are the important parts. Unfortunately the control cannot be added to the AppBuilder toolbox, but if any help you can add to the Visual Designer toolbox and then create a .NET form, add the control to...

If you really do not want to use dynamic queries you can use some of their methods on static queries: DEFINE vWhere AS CHARACTER NO-UNDO. DEFINE QUERY qCustomer FOR Customer SCROLLING. vWhere = "FOR EACH Customer WHERE ...". QUERY qCustomer:QUERY-PREPARE(vWhere). QUERY...

Richard, yes, if client networking or any of the development versions of Progress are installed on the Windows machines then ODBC drivers are also installed so you do not need to download or install SQL Client Access. So you just require new DSN's to be created for the new version of Progress...

For Excel connections SQL Client Access is normally your first port of call rather than the DataDirect drivers. Using these you can easily connect from MS Excel to a Progress DB which is on Red Hat Linux. SQL Client Access provides the ODBC drivers as part of your licenses and will be...

For the other answers something along these lines - rough example only to show what you can check for: DEFINE VARIABLE hTT AS HANDLE NO-UNDO. DEFINE VARIABLE hTB AS HANDLE NO-UNDO. CREATE TEMP-TABLE hTT. hTT:ADD-NEW-FIELD("f1","character",0,?,?,"Field 1","Field 1")...

From Rob's screenshot HEX does not appear to be an option. HEX can be set for some features but you have to know the value: Range("A1"):Interior:Color = &HFFF744. Range("A1"):Interior:Color = 16774980

At one stage there was the possibility I was going to have to do something similar but the project was shelved. I only had an initial look and did not find a .NET approach and this site almost suggests there is none...

I do not know if this relevant but I seem to recall reading that the OpenText method did not always work if the file had an extension of csv and changing to txt solved. Regarding the array, again I seem to recall this had to be an extent of 2 only but not sure. If you change to this does that...

I take it passing the WinForm class as a parameter to the old.p and then passing back the handle to the procedure is not an option? If so, the only thing I can think of is put in extra workings in the old.p to link to the WinForm class and pass the handle to the procedure that way. E,g...

You can do something like this: DEFINE VARIABLE vLabel AS HANDLE NO-UNDO. vLabel = FILL-IN-1:SIDE-LABEL-HANDLE. vLabel:BGCOLOR = 10. Does this solve?

Never used ProWinHandle but the documentation seems to suggest it is used for parenting ABL windows to .NET forms: https://documentation.progress.com/output/ua/OpenEdge_latest/pdsoe/PLUGINS_ROOT/com.openedge.pdt.langref.help/rfi1424919616467.html So wondered if setting the parent would solve...

Fair enough and understand regarding the clean up. The only thing I can think to try is limit the transaction block and not read the records with exclusive locks. Although not quite what you are doing this gives some pointers: https://knowledgebase.progress.com/articles/Knowledge/20150 So...