Search results

  1. A

    Question Procedure or Class?

    Obviously classes and methods are more modern than procedures and functions. Even if you don't use inheritance and class hierarchies and simply use singleton classes as libraries methods allow you to let the compiler check the parameters (works for functions, but not for procedures) but still...
  2. A

    Bad code

    Could this depend on the MIN-SIZE option of the COMPILE statement?
  3. A

    Question Archive a file in a progress table

    The document management system that is included in our product (ERP software) is implemented through an AppServer that stores the files on the file system of the server it is running on. All metadata of the DMS is still stored in the Progress DB. Of course one reason for this decision is that...
  4. A

    Table Decimal field rounding when set to ? decimals

    The oldest version I have installed on my machine is 10.2B. The text reads the same there. (To be precise: OpenEdge Help, entry on Data Types, Decimal.)
  5. A

    Question OE Replication

    A colleague of mine won the DBA and Programmer's Challenge in the 2017 EMEA PUG Challenge (lowest downtime for dump and load). I don't have the technical details, but I understand that he used a generator that writes lots of batch or script files that can run in parallel. It seems that there is...
  6. A

    what is all this pollution

    Would it make sense to appoint more Spam moderators? I'd be happy to help. Alternatively, could you remove or reduce the Report-timeout if I report more than one post?
  7. A

    Table Decimal field rounding when set to ? decimals

    I've only seen a decimals value of ? for other data types, but it seems that ? is legal. You are basically saying you don't want any rounding which is equivalent to full precision, so you would have to set 10 decimals which is the maximum precision Progress allows. Just had a quick look in the...
  8. A

    Question How can I use .cls file from different folder into my procedure?

    If your class is located in the relative path x/y/z/xyzABC.cls you have to reference it by x.y.z.xyzABC.cls. The Type-name syntax entry in the OpenEdge Help describes this in more detail.
  9. A

    FIND FIRST

    Well, you are technically correct, if you refer to catch blocks. I suppose it is useful to catch (138) errors when you are certain that all find statements in a block should actually find a record, ie. it is an error if no record is found. If it is allowed that some records don't exist it is...
  10. A

    FIND FIRST

    Some more nitpicks which seem not to have been mentioned: I think it is bad style to use a dot instead of a colon after a for each statement. I suppose this is some ancient syntax. When I first saw this I wondered why the code compiled. I you want to ask if a record is available you have to use...
  11. A

    DATE function oddity

    Interesting. You are slightly mistaken, though - in the second example the year is 2019, in the third example it is 2001. The default format of mm/dd/yy probably mislead you. My guess is that the same helper functions apply that are active in manual input, eg. you input just month and day in a...
  12. A

    Progress 9.1E : How to fix errn0=22.(781)

    I think your link is broken, but this sounds relevant since it is related to a recent Windows 10 update: Progress KB - Windows 10 shared drive and executables error 781 I agree with you, but please don't exaggerate - Progress 9.1E is from 2004, SP4 is from 2006. 20 years ago 9.0A was released...
  13. A

    The Keyword forget list and other nuggets

    Why shouldn't OF work cross database? It doesn't work magically, it just uses some heuristics to determine which fields are compared and which index is used. In my work OF is usually discouraged. We have one valid use-case where some tables have an accompanying language table which basically...
  14. A

    Progress version 8.3C17

    If you have access to newer Progress versions you could convert the database to a newer version and then use ODBC with that version. I'm not sure if you just need a one-time extraction or ongoing access to the database since you write "bulk extract". If you only need the data once you could...
  15. A

    Question Learing ADM all over again.

    In many cases the smart container doesn't need to know which record is selected, but of course sometimes you need this. The smart container should have handles which point to the running program instances inside it. You can access the smart viewer or smart browse through these handles. (Probably...
  16. A

    Question Learing ADM all over again.

    By ADM(V8), do you mean ADM1 as opposed to ADM2? The application I'm working with is ADM1-only (even in current Progress versions), and I haven't heard about SDO. Judging from the ProKB SDO is an ADM2 thing. When you post what you are trying to achieve I could try to tell what I would do. If...
  17. A

    Progress 8.3b workgroup

    Some of my experience: When I tried to install Progress 8 on Windows XP (to do some data migration for a client running an older Progress application) I needed to enable compatibility mode, then it worked. Later I couldn't install Progress 9.1E on Windows 7 SP1 64-bit (to do some troubleshooting...
  18. A

    Progress' Kbase missing article.

    There is Sample 4GL Socket Programming Code for Server Side, but that article only refers to generic socket programming, not HTTP.
  19. A

    Query

    Sounds pretty inefficient. The INDEX function has an optional third parameter which tells it where to start the search. So you just add 1 to the last returned value and call it again until no more matches are found.
  20. A

    How to identify if a cursor event will leave the fill-in??

    I usually use return no-apply to prohibit leaving a field.
Back
Top