Search results

You can actually rephrase the query into disjunctive normal form, that usually works, even with different indexes for the conjunctive clauses. But in your case you will get a huge query. As an example I rephrased part of your query: for each Activity no-lock where...

See Progress KB 000048200 : http://knowledgebase.progress.com/articles/Article/000048200 "Prior to OpenEdge 11, static temp-tables are fully instantiated when the program that defines them are loaded. Starting with OpenEdge 11, the instantiation of the record and index storage is delayed, and...

Here is the (hopefully current) complete list of special characters: http://knowledgebase.progress.com/articles/Article/000039598 @ . * ! , ~ # At least * and . are the same as in the matches operator. Regarding root: I suppose that means if the Progress _User is named root and you call can-do...

I think being able to abbreviate table and column names (or leave out table names) is worse than abbreviating keywords. I have seen bugs resulting from this (code tries to access some variable which is not defined and the compiler finds some field in some file which is unfortunately unique at...

I'm not totally sure but I think this will make the changes visible for other sessions without the necessity to complete the transaction or to release the record. Of course I don't know if this will help the OP. (I assume it is not necessary to explain what validate is supposed to do.)

Try inserting validate table1. before the pause.

I'm pretty sure that the client only keeps one copy of each record so multiple buffers which point to the same record will be in sync. Small example to show this (using a temp-table but should work the same with a real table): DEFINE TEMP-TABLE ttx NO-UNDO FIELD xy AS CHARACTER. DEFINE...

This error will happen if the record you try to reposition to was added after the opening of the query.

Hi stokefc22, I don't know if this helps but here are some observations I made. In our application compilation speed strongly depends on latency when accessing source files. (The propath usually has a lot of entries and most times are not found before eg. the 10th entry, and we use a lot of...

In my experience Progress does use the most recent trigger definition, but after that also executes a global trigger definition. For example: The following statement is found in a global session service: on F11 back-tab. And in another program I write this code: on F11 do: ... end. Then first...

To be more precise: In which Progress version did adding tables invalidate any CRCs? I started with Progress 9 so I don't know if this was the case with older versions. Adding fields still changes the CRC, but OpenEdge is recently (10.2B?) able to cope with added fields without throwing a CRC...

I also like Tom's method - I wasn't aware that substitute converts ? to "?". Very readable. My usual approach is xyz = "string1 " + (if inputValue = ? then "?" else inputValue) + " string2".which is okay as long as inputValue is not a long expression. Might be a bit faster than substitute, though.

That's documented behavior. You shouldn't use user defined functions in where clauses. There are several knowledge base entries regarding this problem, try searching for the keywords: udf where clause Entry P77953 is very similar to your code. The behavior has not changed in OpenEdge. What has...

After changing either codepage or collation of database you will need to do an index rebuild. You should also adjust the collation for the database server and the clients accordingly, otherwise the resulting behavior might be a bit confusing. ( -cpcoll in startup.pf )

That's the workaround the customer is currently using. (Loading and saving with notepad or some other editor.) The interface to the other software is supposed to be automated - and it was until the switch to UTF-16 (big endian btw.). I now solved this by reading the whole file to a memptr...

Hi Cecil, The file is produced by another software. It seems that older versions of that software wrote normal ASCII files. After an upgrade the software now writes UTF-16 files. (At least that's what I deducted from a sample.) I tried exchanging the convmap.cp but that gives an error message...

Hi Tom, As far as I understood it Steve wants to obmit the decimal point. I can't think of any solution without explicit conversion and processing the resulting string.

Hi Steve, hi Cecil, I'd prefer the following solution, although Cecils code delivers the same result in most cases. It is not necessary to calculate the length yourself. I left out the format option in the variable definition since it is not used in this context anyway. DEFINE VAR ckamount AS...

Hi everybody, I am currently trying to process a UTF-16 text file with Progress 9.1E. At first I thought this would be easy, just input stream ImStream from ... convert source 'utf-16':Ubut then I found that UTF-16 is only supported starting with OpenEdge. Unfortunately the particular customer...

That makes sense. The reason I noticed this is that when I inspect indices with on of our development tools I get messages like ** Value 1179821244 cannot be displayed using >>>>>>9. (74) because the format of _index._Mod-sequence only has 9 digits but the values are 10 digits. I will suggest to...