Recent content by MattKnowles

  1. M

    Answered Hanging AppServer

    We currently have a customer whose application hangs most mornings not allowing log in. Stopping and restarting the AppServer seems to fix this. I've put debug into the offending routine outputting this to the AppServer log. Unfortunately the debug seems unhelpful as it indicates that the...
  2. M

    South Wales

    That had crossed my mind but I assumed that they'd be rather careful with their customer information. Maybe not :) Matt
  3. M

    South Wales

    Following a conversation with my wife a couple of months ago I've periodically tried to find out whether there are any users of Progress in South Wales. If there are then Google searches don't seem to have found them for me. Do any of you know of any? Ta Matt
  4. M

    Suppressing SYSTEM ERROR 22

    While running the assign rcode-info:file-name = cFile no-error. command across a somewhat flakey network I occassionally (rather too occassionally!) get a SYSTEM ERROR: I/O error 22 in readit..... Do any of you know a way that I can trap this error (suppressing the message) so that I can...
  5. M

    Urgent

    I was going to answer but failed to understand the question. It is a question isn't it?
  6. M

    CRLF Line terminator equivalent in Progress 4GL

    As stated above CR is chr(13) or ~r and LF is chr(10) or ~n. These can be used together or independently as your need requires. Therefore if you need a file with the line delimiters of only LF then only use chr(10) or ~n.
  7. M

    Checksum validation

    One of our servers shutdown when it ran out of memory. Once it was rebooted we went to restart the database and got a couple of errors like the one below: BROKER 0: (14410) Checksum validation of dbkey 407113024 block type 2 in area 23 does not match data. Expected: -5577 received 21849...
  8. M

    efficiently remove spaces

    My instinct tells me that it's the first example although I have nothing definitive to back this up with. If it were my code then I'd certainly use the first method, probably without the if statement, ie l-txt = REPLACE(TRIM(l-txt), " ", " "). Although, having said this, the 'do while' does...
  9. M

    XREF and temp-tables

    I just couldn't bring myself to type 'new shared'! Bah, I've just done it! Going to have to iron my hands now as punishment.
  10. M

    XREF and temp-tables

    New Shared? <shudders>
  11. M

    OS-Error: Unmapped error

    When using the os-copy command to copy a file to a remote server I am checking the os-error to report any failures. Many of these return "Permission denied" which is good - at least it shows that it's working :) However, some files return the os-error 999: Unmapped error. I'm able to...
  12. M

    RCode-Info:Table-List

    We have five to six thousand GUI routines that once compiled need to be distributed across a WAN to various developer sites across the UK. While the compile itself is not too painful the distribution itself can take well over an hour. This means that the downtime resulting in a 5 minute DB...
  13. M

    RCode-Info:Table-List

    I have been using rcode-info to identify tables that reference particular tables in order to give us an idea of how many files will need to be compiled following a DB change. This works well on the server where all our routines connect directly to the DB and so the rcode contains a reference to...
  14. M

    Bookmarks in Word 2007

    Nice one, many thanks.
  15. M

    Bookmarks in Word 2007

    I'm trying to insert/read values from bookmarks in Word 2007. I recorded the macro to do this and translated it into Progress code and got as far as: define variable chWord as com-handle no-undo. define variable chDoc as com-handle no-undo. define variable chBookmark as com-handle no-undo...
Top