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...
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...
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...
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...
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...
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...
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...
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...
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...
Is it possible to configure write-xml so that it doesn't replace <B> with <B>
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...
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...
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...
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...
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...
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...
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...
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...
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...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.