Search results

  1. 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...
  2. 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...
  3. 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...
  4. 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...
  5. 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...
  6. 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...
  7. P

    Answered dataset save rowid as part of the temp-table

    Hi All, I am new to datasets and I am trying to copy an entire database table to a dataset temp-tables along with 1 extra field which is a holds the database table record rowid . I am trying to do this in three stages 1. All the data is copied to the corresponding temp-table fields using a...
  8. P

    Resolved Explain property and data member differences and when to use final

    Hi all, I have been asked to do some coding on a project that uses classes. It has been a while since I did OOP in college and when I did before it was with java. I am struggling to understand a few concepts and I have a few questions that maybe one of you could answer. Just to explain what...
  9. P

    Answered Is using Temp tables and locking bad coding standards

    Hi all, Quick question, is using lock statements (no-lock, exclusive-lock) when doing searches on temp tables considered bad coding standards? See example below. Now before anyone says anything note the below is a simple example for illustrative purposes only. DEFINE TEMP-TABLE...
  10. P

    Answered Write-xml no escape character <

    Is it possible to configure write-xml so that it doesn't replace <B> with &lt;B&gt; I have several letters that are broadly the same, so instead of using 1 xsl for each letter I output the data using a temp table. I have the following code snippet which creates an xml file, to be read by fop...
  11. P

    Answered What is the purpose of a CRC check on database trigger

    Hi All, I know the whole idea by CRC checks, to ensure that if the database has been changed since the code was last compiled that a front end error is generated. But can anyone advise me what the purpose of a CRC check on a database trigger is. This has a checkbox which appears to be...
  12. P

    Resolved Help with SendEmail (progress dynamics)

    Hi folks, As part of a system error checking I am doing I need to send and email to the support team when a error occurs. Can someone help me please as regards SendEmail. I am trying to figure out how this works and get it to work for me. I have created a program sndemail.p (below). I am...
  13. P

    Answered Pasting characters into a Password field

    Hi folks, I am wondering if anyone can help me here. Users have asked for the ability to paste a password from one application to a progress application. I see that by default you can not paste into a password field in Windows. I can paste into a password field in progress under Unix. I...
  14. P

    Answered Can I force Excel to automatically open a UTF-8 csv file correctly?

    Hi all, I have an application that outputs a csv file in the charset UTF-8 and opens it in Excel. Currently I'm having problems with Excel and UTF-8. When it opens a file with a umlaut character. The character fails to display correctly. Does anyone know if it is possible to instruct excel...
  15. P

    Question Passing datasets: should I pass as handle or dataset-handle?

    Hi guys, I am wondering if someone could advise me here on something regarding passing data-set between procedures. If I use the following code snippet as an example . DEFINE TEMP-TABLE tt-ch no-undo SERIALIZE-NAME "datarow" FIELD account-id AS CHARACTER SERIALIZE-NAME...
  16. P

    Is using define temp-table with a like option bad coding standards?

    Hi does anyone know is using define temp-table with a like [database table] option considered bad coding standards in PROGRESS ABL. I have never heard this before and am wondering if anyone else has ever heard this. One of the person I work with consideres it bad. If the database has to change...
  17. P

    Assigning a progess variable from a javascript variable

    Hi, i am wondering if anyone can help me. Does anyone know, is it possible to assign the value of a javascript variable to a progress variable. I have two frame in a window. The left frame shows a report and the right frame show the parameters for the report. When the report is selected...
  18. P

    Drawing bar and pie charts in webspeed.

    Hi all, Does anyone know how to output pie charts to screen in webspeed. Do I need a tool to do this, could anyone recommend one. Thanks
  19. P

    Call a local procedure from click of a button using ajax.

    Hi folks, Sorry if this is a stupid question. I have a Sales Report program that displays sales information to web screen in webspeed. This query on the database is run on the server side. The results are stored in a temp table and are passed from server side to web browser. I have to do an...
Top