Search results

  1. W

    4GL code to copy a value to windows clipboard

    UPDATE: 4gl command is CLIPBOARD. Found it in the reference manual. CLIPBOARD: VALUE = "zxxx" or variable . I know this is in 'search' somewhere, but with search no appearing to work I'll have to post it here. I thought there was some sort of system command that could be used to take a...
  2. W

    Site functionality

    I am having the same issue, going to try again using a VPN
  3. W

    Question End Progress operation from bat file

    The problem fixed itself and we have no clue as to why. It was there, then it was gone.
  4. W

    Question End Progress operation from bat file

    It appears that whatever was happening is no longer happening. (Is that not always the case!) We made no changes at all and suddenly the problem was gone. We had thought that some form of improper shut-down was causing it and tried to force every task we could to test the issue. Nothing. So...
  5. W

    Question End Progress operation from bat file

    Good morning all, and it appears that the issue had nothing to do with the .bat file and the settings being used. While we are still testing the theory, it appears that because of a corporate policy forcing both the local PC and the RDC connections to go into a 'sleep' mode, when reactivated a...
  6. W

    Question End Progress operation from bat file

    Thank for all the thoughts. I wrote the original code in the .p, and as I said, ran fine for more than 10 years. What is happening is best examiined in the Task Manager of the Windows server. But this may help more. We run both a windows version of progress and a UNIX version. The DB is on the...
  7. W

    Question End Progress operation from bat file

    Good day all. We have a batch file that runs from Window Task Scheduler, and runs every 15 minutes on a dedicated server. What is now happening it appears that after 10 years, the 'process' is being left running. Here is the current batch code.: C:\Progress\OE111\bin\prowin32.exe -db xxx.db -H...
  8. W

    Open Excel without MS Office

    Thanks for the info. They are only to be on this system for about 18 or more months, and I feel they are not going to want to invest further.
  9. W

    Open Excel without MS Office

    UPDATE: Management is deciding what they want to do. We can open the files just fine, just can't save and/or create any new ones. Thanks all.
  10. W

    Open Excel without MS Office

    The very higher ups for the company I contract for, have decided that the new 'server' that handles the Progress ERP will not have Office 365 installed. What that means is that is any application developed that makes calls to read / write to an excel sheet will not work w/o asking for a log in I...
  11. W

    Question More Excel Questions and COM Handles.

    Thanks for the info. The system I am using does not have the COM viewer installed. I think I can use what you had from the screen shot to get what I need. I'd had seen those 'values' before, just didn't have a clue as to what the parameters were. Trying to just use the macro as a source if very...
  12. W

    Question More Excel Questions and COM Handles.

    I was wondering if there is a document here that fully explains how to properly use some of the functions in excel? Take for example the function (?) autofill, it is looking for 2 or so parameters, but no real reference on what or how. I've seen the codes from the xs-web site for things like...
  13. W

    Macros, run an Excel macro from 4GL

    The problem I am now having is that the macro I want to run is stored in personal.xlsb, and if I use the standard progress code, it is not pulling in that file. If there is no way to have progress load that info, the ability to run a macro becomes extremely limited. In as much as this test macro...
  14. W

    programmable virtual keyboard development

    I just saw this older post and if I works for what I need, go grab yourself a beer and send me the bill. -Dennis-
  15. W

    Macros, run an Excel macro from 4GL

    Greeting all! I am trying to determine if there is a method to call a stored macro (excel) from a program? From what I have read, I could use the code from the macro and embed it into the .p / .w, but some of the sheets I work with will change and it is just easier to modify the macro then try...
  16. W

    Question Using a query to update values.

    On the ribbon bar there is a drop down of 5 or so values.. The user would select one, hit a button that would walk thru records and apply that value to the a field in the column for each row on the current browse. You can determine row ID value of a row in a browse and you can do a trigger that...
  17. W

    Question Using a query to update values.

    I believe including the actual query build code is in order. That way you can see just how complicated the query is. While I'm uploading this as a .p, in fact it is an internal procedure within the .w program. In short, is scans all the 'filters' , which are drop-downs, and builds and executes...
  18. W

    Question Using a query to update values.

    Thanks for the info, but I already have a very complicated multilevel search procedure written. What I was trying to do is to use the query and reset on of the fields in the querred temp-table to a pre-defined value. So all the rows in the frame are results of the query, but the question then...
  19. W

    Question Using a query to update values.

    Thanks for responding. I am trying not to have to do that as the actual query build is very long. There are maybe 9 different filters that are used and need to be tested. So, for example, I'd have to test each screen-value with something like " assign " and if x:screen-value <> ""...
  20. W

    Question Using a query to update values.

    Hi all, hoping all are doing well. I have a query, freeform, that is built dynamically based of values set from a group of drop down values. This allows, much like excel, for the user to build their own query on the values they need to filter by. Works great. However what I'd like to do now is...
Back
Top