Recent content by Rob Fitzpatrick

  1. Rob Fitzpatrick

    Comment ABL Toast Notifications

    It's an OS notification mechanism where a small panel slowly pops up in the corner of the screen, in a manner reminiscent of a piece of toast popping up from a toaster; thus, "toast notification". The panel contains a short message and the name of the application or OS component that created...
  2. Rob Fitzpatrick

    DB Backup script

    Given both the syntax and the .sh extension, that is a Unix shell script. You would run that to back up a database on Linux. You will need to translate it to the appropriate syntax for a scripting language on Windows, e.g. a batch file (.bat) or a Powershell script (.ps1).
  3. Rob Fitzpatrick

    Track Structural Changes in DB (Auditing not enabled)

    If you have an audit requirement, i.e. you need to provide data from an audit trail that is uninterrupted, unimpeachable, authenticated, and secure, to satisfy an auditor, use OpenEdge Auditing. Any solution short of that, which captures similar information, is just logging. If you don't want...
  4. Rob Fitzpatrick

    Sqlexp

    This KB may also help: https://community.progress.com/s/article/20143
  5. Rob Fitzpatrick

    Sqlexp

    Your user SQLUser is unable to read data because your attempt to grant it select permissions failed. First, check who has such permissions; look in the sysdbauth table. E.g.: select * from sysprogress.sysdbauth;
  6. Rob Fitzpatrick

    Answered Question on xcoding

    Not all code changes alter the length of a source file, e.g. fixing a typo of transposed characters in a string, changing an operator (e.g. ">" to "<"), changing the value of a constant, etc. Such changes would result in a different xcoded file with the same length as the prior one.
  7. Rob Fitzpatrick

    OE Studio / GitHub integration

    It looks to me like PDSOE is not the future for OE development. It isn't completely abandoned, like OE Studio, but in my view the writing is on the wall. In Progress' roadmap talks, they talk about supporting Language Server Protocol, which will ultimately allow you to use your IDE of choice...
  8. Rob Fitzpatrick

    Answered Question on xcoding

    An xcoded file will always be one byte larger than the source file: as I recall, the first byte is always 0x13. It sounds like you're rolling your own checksum algorithm. Couldn't you just use an OS tool like diff to compare two xcoded files? Also, is there any possibility that some of your...
  9. Rob Fitzpatrick

    Upgrade from 9.1E to 12.8 (Windows)

    @JLovegren I've written about a general approach you can take in this thread. That was about going from 10.1A to 11.7 (i.e. across one major-version boundary), so it's relevant for your journey.
  10. Rob Fitzpatrick

    Copying a Procedure Library

    I've done this in the past. It works, as Tom points out, if the r-code in the PLs doesn't use any incompatible OS-specific features (e.g. assuming a GUI library is in the propath in a tty environment).
  11. Rob Fitzpatrick

    Question Progress User Named/Seat License for developing platform

    From 3.4.2: One of the attributes of a Progress license model is whether it is single-server or multi-server. Named User is multi-server. In your case, you can install this one license on your three servers. You didn't mention which product this is. I mention that because some product use...
  12. Rob Fitzpatrick

    -n value maximum number of user

    The -n parameter doesn't affect how many users you can define, if by "define" you mean "create". The -n parameter determines how many users can connect to the database at the same time. You can see how many users were purchased for each of the product licenses that are installed on the server...
  13. Rob Fitzpatrick

    -n value maximum number of user

    Of course. Every setting has a limit. The -n parameter determines how many database connections you can have concurrently. It includes all types of connections (4GL clients, SQL clients, utilities, helper processes, etc.), except for servers and brokers. The question shouldn't be about the...
  14. Rob Fitzpatrick

    Skipping An Unavailable Record

    Correct. The AND AVAILABLE ttcbc is equivalent to AND TRUE (unless you were doing something like releasing the ttcbc buffer prior to the if available, which you are not). It doesn't accomplish anything. Why do you think it is required? Original: Revised: Why did you add the qualification of...
  15. Rob Fitzpatrick

    Database migration to different server (lift and shift)

    A modern Linux machine very likely isn't going to run an old Progress version like 9.1D; it won't have the required libraries. But if you have source code for your application then you can compile it under a modern release of OpenEdge and run that on Linux. The current release is 12.8. If you...
Top