Search results

  1. O

    How to use font after creating it at runtime

    The only options I know of is as per this article: https://community.progress.com/s/article/18493 Or something similar to this very old code snippet from many years ago: DEFINE VARIABLE Font1 AS INTEGER INITIAL 1. DEFINE VARIABLE Font2 AS INTEGER INITIAL 2. DEFINE VARIABLE FontSelect AS...
  2. O

    Question How do I use Windows Hello Authentication (Windows.Security.Credentials)

    Yes, this seems to be hidden deep as there is no indication of where it can be found. I do not know if what is posted here is any help: https://stackoverflow.com/questions/44093544/how-to-install-windows-security-credentials-c-sharp-net-vs-2017
  3. O

    SELECT-NEXT-ROW returns true when on last row of browse

    These things are never easy! So I am guessing the problem is that the CTRL-TAB is only applying to the master window and not others? Is it possible in the master window you can get a handle to either the procedures, window or browse and if so set a CTRL-TAB specific trigger to the handle...
  4. O

    SELECT-NEXT-ROW returns true when on last row of browse

    For a generic context you could iterate through the browse columns and check that way: DEFINE VARIABLE brws-col-hdl AS HANDLE NO-UNDO. DEFINE VARIABLE browse-hdl AS HANDLE NO-UNDO. DEFINE VARIABLE i AS INTEGER NO-UNDO. browse-hdl = BROWSE bwsItem:HANDLE. DO i = 1 TO browse-hdl:NUM-COLUMNS...
  5. O

    SELECT-NEXT-ROW returns true when on last row of browse

    Never used SELECT-NEXT-ROW so not sure the best solution. One idea is to check what has focus and if a cell then remove focus. A really rough example only but hopefully it gives some ideas: ON CHOOSE OF cmdSelectNextRow IN FRAME fMain /* SELECT-NEXT-ROW */ DO: DEF VAR rv AS LOGICAL NO-UNDO...
  6. O

    OS-COMMAND Won't Run With a Variable Path

    Use the VALUE function: OS-COMMAND SILENT VALUE(cDir4Control + "HT\Website.bat").
  7. O

    Question How to receive a handle in an External Procedure

    As Cecil posted, I think LONG is what you are looking for. I have rarely interacted with DLL's but I have seen examples like these: PROCEDURE GetSysColor EXTERNAL "user32.dll": DEFINE INPUT PARAMETER nIndex AS LONG. DEFINE RETURN PARAMETER iWinColor AS HANDLE TO LONG. END. PROCEDURE...
  8. O

    Question Error “System.ObjectDisposedException: Cannot access a disposed object.”

    With what I had to do and what you have found it does seem to suggest that the FormClosing method requires some actions to solve.
  9. O

    Question Error “System.ObjectDisposedException: Cannot access a disposed object.”

    I had something similar once, and like you it was only happening in different environments. I was not able to fathom out what was going on but it seemed some sort of repeat was going on and the close/exit was being applied twice. The second close was giving the error as the object did not...
  10. O

    .NET OCX on Progress 12.8

    Some of the components in mscom.ocx may already be naturally available as .NET components so you may not have to download or install anything. In Progress Developer Studio create an ABL form and if you expand Toolbox-Microsoft Controls it will show all the components available - see attached...
  11. O

    Open Excel without MS Office

    As Cringer posted, one option is to create Excel XML files, and although you can not create with advanced features they do not require any interaction with Excel. Apart from DocxFactory, a pure Progress solution to create Excel XML files is to use xmlspreadsheet.p written by Tom Bergman. I...
  12. O

    Answered Assembly.xml

    Also to add, for actual deployment if users are only running compiled programs then they do not actually require access to assemblies.xml. When you run from r-code, you don't need the assemblies.xml file because the assembly-qualified name of all referenced classes are in the r-code. If...
  13. O

    Answered Assembly.xml

    For PDSOE I normally just place in the relevant Project folder and it is automatically picked up. Another option is to set using the -assemblies parameter for the PDSOE project startup parameters - see attached.
  14. O

    How to clear the SCREEN-VALUE of a character LIST-ITEM-PAIRS combo-box

    Seems you have hit on the correct solution: https://community.progress.com/s/article/P21248 This is useful to know and better than using this method: https://community.progress.com/s/article/18664
  15. O

    How to solve looping problem

    This line is the cause because you have icsw.cono = icsw.cono: can-find(first icsd where icsw.cono = icsw.cono and icsd.whse = icsw.whse and icsd.ecommercety = 'y' no-lock) Change to icsd.cono = icsw.cono - you also do not require the no-lock for a can-find: can-find(first icsd where...
  16. O

    Question More Excel Questions and COM Handles.

    Although not Progress, a good alternative is to download the "Excel 2013 Developer Documentation.chm" file - Download Office 2013 VBA Documentation from Official Microsoft Download Center - and even though it is for an older version very useful because as you can see from the attached it works...
  17. O

    Question More Excel Questions and COM Handles.

    I initially thought that the Progress COM Object Viewer listed them all but as can be seen from the attached not the case. There are sites such as these that list the numeric values: https://learn.microsoft.com/en-us/office/vba/api/excel.xlautofilltype...
  18. O

    Macros, run an Excel macro from 4GL

    You can certainly run macros contained in other files using something similar to this: hExcel:Run("'Another Workbook.xlsm'!NameOfMacro"). As for loading info from another workbook that could be possible and think I did something similar many years ago but it is so long ago just cannot find it...
  19. O

    How can I export table with array columns

    Really surprised by this as it appears to by design: https://community.progress.com/s/article/P116984 Can you apply the suggested resolutions? If you need to export multiple tables then this dynamic option may be useful: https://community.progress.com/s/article/P4410
  20. O

    Macros, run an Excel macro from 4GL

    It is certainly possible to run an Excel macro from 4GL, and as a quick test created a simple macro in an Excel file which was the following: Sub Macro1() MsgBox "Hello World." End Sub Running this code in 4GL gave the message: DEFINE VARIABLE hExcel AS COM-HANDLE NO-UNDO. DEFINE VARIABLE...
Top