Search results

  1. PatrickTingen

    Progress 9.1D legacy server - no developer licence - need to dump data to .csv

    I dusted off an old version of DataDigger and got it running in v9. Don't ask why I keep a copy of v9 :) Check the repo at GitHub - patrickTingen/DataDiggerV9: DataDigger for Progress v9 or simply download it here It contains both source files and .r files for v9.1D Extract the zip in...
  2. PatrickTingen

    When something is not true

    Alternative approach: #Tray: FOR EACH tray NO-LOCK WHERE tray.tf-own = l-cus AND tray.tf-type >= l-type1 AND tray.tf-type <= l-type2 AND tray.tf-delete-date = ?: FOR EACH item NO-LOCK WHERE item.if-tray = tray.tf-tray AND...
  3. PatrickTingen

    When something is not true

    Try this FOR EACH tray NO-LOCK WHERE tray.tf-own = l-cus AND tray.tf-type >= l-type1 AND tray.tf-type <= l-type2 AND tray.tf-delete-date = ? , EACH item NO-LOCK WHERE item.if-tray = tray.tf-tray AND item.if-delete-date = ? BREAK BY...
  4. PatrickTingen

    Problem with etime in smtpmail.p

    Cool, the most recent version is only 22 years old I found a revised version from 2009 here: https://freeframework.sourceforge.net/downloads/accepted/
  5. PatrickTingen

    Problem with etime in smtpmail.p

    Ai, guilty.....
  6. PatrickTingen

    Problem with etime in smtpmail.p

    For the past few days, I have been receiving blank emails from our ERP system. We have several places where the system mails strange things so sending mail is not uncommon. Blank emails are, though. I managed to trace the mails back to the specific server and checked the logfiles of smtpmail...
  7. PatrickTingen

    Resolved Permanent Endless-Job and (5408) WARNING: -l exceeded. Automatically increasing from 1580 to 1590

    Not sure, based on your example, but my experience is that if you encounter strange problems with locking, you can do yourself an enourmous favour by using explicit buffers for each table you reference. No exceptions; always use a buffer. I've seen multiple times strange and seemingly unsolvable...
  8. PatrickTingen

    Index Questions

    With the DataDigger, you can use the built-in query analyzer. It will report both the nr of reads and the time it takes for a query to run. You can get it here if you don't already have it
  9. PatrickTingen

    Question Using a query to update values.

    This might be a language issue (English is not my native tongue) but I think I don't understand what it is that you want to achieve. Your query looks good; you build a truly dynamic query and then attach it to the browse. So your user selects a couple of filters, you build the query, attach it...
  10. PatrickTingen

    Smartbrowse loses link to smartviewer

    Can you use the debugger to step inside 'isOkToFetch'? You might be able to find why it says 'no'
  11. PatrickTingen

    Question Using a query to update values.

    I am not fully sure what you are trying to do but it looks as if you are making your life extremely complicated by mixing UI and logic. You use the screen-value of your filters in the query, if I am correct. By building a dynamic query, using the actual value from the filters (not a reference to...
  12. PatrickTingen

    Question Using a query to update values.

    If I read your response, I think you may have a partially dynamic query, one that uses or does not use fields from the frame. A fully dynamic query would look something along the example attached. Look in the choose event of the button In this demo I just copied the records from the customer...
  13. PatrickTingen

    Question How to drag and drop an editor field widget using mouse out of an child frame widget into another child frame widget (or the parent frame)

    Indeed, that was what I meant, but I can see your case for usage of frames (scrolling) so I think it is wise to stick with that. However, what might be possible is to delete the widget when you move it from one frame to another and then re-create it in the new frame, like @Cringer mentioned.
  14. PatrickTingen

    Question How to drag and drop an editor field widget using mouse out of an child frame widget into another child frame widget (or the parent frame)

    In that case, perhaps another way to look at it is to determine the coordinates of the editor when you drop it. Based on that you know where they want the shipment to be in the schedule. Then at that point change the data underneath and just redraw the screen. No need for reparenting and - bonus...
  15. PatrickTingen

    Question How to drag and drop an editor field widget using mouse out of an child frame widget into another child frame widget (or the parent frame)

    I don't think it is possible at all to re-parent a widget. I tried building a small example, but when I try to set the new parent for an editor, Progress forbids this: But you can just move the field around, test it with the attached program. Uncomment the lines in the procedure...
  16. PatrickTingen

    Error reading Outlook folder

    We found the issue. The new Outlook version handles shared folders and caching different than the old one. More info: Manage download settings for shared mail folders in Cached Exchange mode in Outlook - Outlook
  17. PatrickTingen

    Error reading Outlook folder

    I don't think this is the issue; we can connect to Outlook without any problem, it fails when we try to access the "Folders" property. We are pretty sure it had something to do with permissions / authorization. When we try to read our own (a non-shared) mailbox it works fine.
  18. PatrickTingen

    Error reading Outlook folder

    Yes, we handled that in the trust centre
  19. PatrickTingen

    Error reading Outlook folder

    We are in a process of migrating our servers and we are strugging with a mail problem. Old server: windows server 2012R2, Progress 11.2, Outlook 2013 New server: windows server 2019 Data Center, Progress 11.7, Outlook 2019 What we do is running a progress program via the task scheduler to save...
  20. PatrickTingen

    Question Excel extraction

    You could also take a look at GitHub - rodolfoag/4gl-excel: Library to create an Excel file from Progress 4GL where this is already solved. I used this to create the dump-to-excel in DataDigger (code here: DataDigger/wDump.w at master · patrickTingen/DataDigger starting at line 1594)
Back
Top