Search results

I'm fairly sure you don't want to use the accumulate function. Its main use is to provide totals and counts for a range of records. e.g. FOR EACH InvcTax: ACCUMULATE InvcTax.TaxAmt(TOTAL). END. DISPLAY (ACCUM TOTAL InvcTax.TaxAmt). From what I am reading, you need only define a variable, set...

I don't think you can do this easily. Conditional compilation is out because it will take the status when you compile (probably not on batch mode). The only solution I can think of would be to have 2 versions of the object code (.r) and make sure that the correct one appears first in your...

The FIND statement can only ever use one index. The FOR EACH statement can use multiple indexes. Example Table1 Field1 Field2 Index1 - Field1 Index2 - Field2 FIND FIRST Table1 WHERE Field1 EQ Value1 AND Field2 EQ Value2. This will only use Index1. FOR FIRST Table1 WHERE Field1 EQ Value1 AND...

I have a question as to how shared memory is used and attributed to Progress Databases. On a Sun OS UNIX box with shared memory segment size set to 64Mb. If I start my database with 8000 buffers, I use 66Mb (2 segments). If I start my database with 7500 buffers, I use 62Mb (1 segment). Have...

In shared memory systems, each addition database buffer takes the same memory as the database block size. If your database block size is 8K, you have just added an extra 3000 * 8K of memory requirement. Other parameter increases that affect memory are: -D 100 bytes each -L 16 bytes each -Mxs 1K...

The field-pair-list in your buffer-copy method does not allow for functions. Try this instead /* populate requested temp-table */ FOR EACH padepts: bh:BUFFER-CREATE. bh:BUFFER-COPY(buf-t1-hndl). ASSIGN fld1 = bh:BUFFER-FIELD("fRECID") fld1:BUFFER-VALUE = RECID(padepts). END.

We have a WebClient Application that has - The configuration file (prowcapc) on a file server - file://... The component files (cab) retrieved by appserver - appserver://... Using the above setup, everything works OK, but we have to distribute the prowcapc file to a series of file servers...

As far as automating promon goes, I have successfully worked with the following in the past.echo "8" > promon.in echo "1" >> promon.in grep username database.lg | tail -1 | cut -f1 -d "," | cut -f2 -d "m" >> promon.in echo "x" >> promon.in echo "q" >> promon.in promon database < promon.in >...

Tony, I posted a browser search procedure a while back. http://forums.progresstalk.com/showthread.php?s=&threadid=38232 Not 100% sure about your reposition problem, but I suspect you're right that it may be because you're tring to use the second query buffer.

Here's some "bones" to examine. You can vary the message based on the return value $?. (Different versions of UNIX/Progress give different results). proutil database -C busy > /dev/null 2>&1 if [ $? = 0 ]; then echo "Database database is down" > alert.d mailx -s "DATABASE DOWN"...

Is there any method of restricting the amount of information written to the database log file? More specifically, We are running with Stateless Appservers. Every time someone uses an AppServer it reconnects to the database using their USERID and Password. This produces an excessive amount of...

Adding a new index will change the table's CRC value. You will need to recompile any program that references that table (not necessarily the whole application)

His profile shows him as being last active at 3.10 this morning. Maybe he's just back from holiday.

Try this (V9+) DEF VAR hBuffer AS HANDLE NO-UNDO. DEF VAR hQuery AS HANDLE NO-UNDO. DEF VAR billigCounter AS INT NO-UNDO. DEF VAR cTable AS CHAR NO-UNDO. ASSIGN cTable = FILL-IN-2:SCREEN-VALUE. CREATE BUFFER hBuffer FOR TABLE cTable. CREATE QUERY hQuery. hQuery:ADD-BUFFER(hBuffer)...

You don't know how long the original string was. ENCODE always returns a 16 character long string of upper and lower case letters. There are 52 to the power of 16 possible combinations, but an infinite (as near as dammit) number of original strings. Just because one matches doesn't mean it's...

Sascha, I am thinking of a number, iNum, between -999999 and 999999. iNum MODULO 11 returns 3, and will always return 3. Can you tell me what iNum is? No! I suspect that Progress ENCODE will do something similar, but far more complicated than the above example. If you want to Decrypt...

Try this FOR EACH _Area NO-LOCK WHERE _Area-Name EQ "My_Area", EACH _StorageObject NO-LOCK WHERE _StorageObject._Area-Number EQ _Area._Area-Number AND _StorageObject._Object-Type EQ 1, FIRST _File NO-LOCK WHERE _File._File-Number EQ _StorageObject._Object-Number: DISPLAY...

I think the above quote shows the important thing you are missing Mark. Converting integer to time string is easy. Going the other way isn't. ;) I was advised at my Progress V6 to V7 jumpstart course in 1997 that Progress could offer a time-based data type. But instead they were going to finish...

Sorry about formatting. The information is on edoc Database Design Guide Table 4.2 Datatype Bytes (Value) Character 1 + number of characters, excluding trailing blanks. If the number of characters is greater than 240, add 3 to the number of characters instead of 1. Date 3 Decimal...

I think that either your PROTERMCAP file or TERMinal emulation has changed. If you go to your tramlines, shell to UNIX and enterecho $PROTERMCAP echo $TERM you should be able to see the values to which they are assigned. By looking in the PROTERMCAP file under your TERMinal emulation's section...