Recent content by progdev1

  1. P

    Answered Truncating before image file, do i need to backup the database first?

    That is all really good to know. Thanks for your advice
  2. P

    Answered Truncating before image file, do i need to backup the database first?

    It is an Enterprise license. Looking at the version of progress on the server it is 10.2B02, I am in the process of moving the client up to 08, but this will take time. I used proutil package -C describe. I don't see any AI extents in the st file so I don't believe that is in use. As there...
  3. P

    Answered Truncating before image file, do i need to backup the database first?

    H Rob & Tomi, thank you both for your replies. Hi Tom, It is good to know that I don't need to truncate the database. In the case that the bi file grew suddenly and I need to do work before the weekend, that would be the faster option. You point about the bi file being fairly static and that...
  4. P

    Answered Truncating before image file, do i need to backup the database first?

    Hi, My clients progress (10.2B) database has a bi image approaching 1.5GB. The limit is 2GB. The database extent that has grown is It is a before image file [database name].b2. I am debating whether I should just prostrct add a few new extents or just truncate the bi file. The problem I have...
  5. P

    Answered Can I use a For Each for dynamic input in some circumstances

    Okay good approach. But either way it needs a query. Thanks.
  6. P

    Answered Can I use a For Each for dynamic input in some circumstances

    Hi All, I have a code that goes ASSIGN dtLastUpdate = TODAY - 30. FOR EACH ORDER WHERE depot-num = currentDepot AND last-update >= dtLastUpdate NO-LOCK: EXPORT ORDER. END. I have a new request to give the user the option to choose all date as well as the...
  7. P

    Answered Dump And Reload - Can I Reduce The Fixed Database Size.

    Thanks for everyones assistance on this. Just to provide some further info on how I got on with this. I was able to make the database smaller and I was also able to make the extents all the same size. The database ended up being larger than I anticipated. It was 27GB(Table 22.5GB and Index...
  8. P

    Answered Dump And Reload - Can I Reduce The Fixed Database Size.

    Hi, My client uses Progress 10.2B on Linux. The database currently uses 45+GB on the hard disc. It hasn't been dumped and reloaded in years. So fixed extents were just added on every time the database needed to grow. When I do a database analysis it says the actual database size 17.4 GB...
  9. P

    Answered Is It Possible To Get Record Lock Duration

    Thanks for your tips I'm on OE10.2b patch 08 by the way. We have an app this is primarily business hours. In theory we could have users in the system at the time when the end of day runs, unlikely but possible. Hence I'd rather just disconnect users with a long record lock. The problem we...
  10. P

    Answered Is It Possible To Get Record Lock Duration

    Does anyone know if it is possible to get the duration that a record have been locked for via a program? I know it is possible to get a transaction duration using virtual system table _trans. But this does not help me because share-locks don't generate a transaction. Our software supplier...
  11. P

    Answered When Is Appropriate To Use Of Nested For Statements

    Thanks a million for that. As regards release statement. You are correct, I tend to put them in out of habit. I read about this recently and it should also be noted that a release statement doesn't release the record straight away. What it does is tell progress you want to release the...
  12. P

    Answered When Is Appropriate To Use Of Nested For Statements

    Hi, I have a quick question related to nested for statements. By nested FOR statements I mean FOR EACH customer NO-LOCK, EACH sales-order WHERE sales-order.customer-id = customer.customer-id EXCLUSIVE-LOCK NO-ERROR: ASSIGN sales-order.status = "archive". END. When I started...
  13. P

    Answered Does Opsys Function Return Ms-dos Anymore?

    Very good point regarding the Progress Version. In my case the progress version 102B. I assumed incorrectly that opsys always returned a value based on the windows operating system version. But now I see the value returned is actually based on the Progress version. This is good to know and...
  14. P

    Answered Does Opsys Function Return Ms-dos Anymore?

    Hi folks, I am re-writing an old program. The code is similar to the below. I know that op-sys can be overridden manually but I don't think that this applies in this case. I always assumed opsys only returned ms-dos for windows 3.1 and earlier machines; basically ever since Windows 95, it...
  15. P

    Answered Consecutively run two procedures

    The following comes with a health warning - I haven't used smart objects in a good few years. I created a smart window swin-1.w, a smart data object that queried the sports2000 customer table, a smart browser and a smart panel to navigate the smart browse. I successfully linked all the smart...
Top