Recent content by raptor

Hello Next strange thing... A fried creates a list of a few thousand records using a daterange and a code as filter. On his PC the result is wrong. There are also records which don't have assigned the selected code. I copied the database and all r-files to my pc. If I run this list with the...

Ok, the problem was in the max-value of the sequence. Thank you for your time and have a nice weekend!

Fun is something different for me. :-) Sequence limit can be the reason, i will check it immediately.

This is the create-trigger of this table: TRIGGER PROCEDURE FOR CREATE OF mailing. def var l-ml_nr like mailing.ml_nr. def buffer b-mailing for mailing. {syvar.i} {symon.i} IF g-during_load = false THEN DO: BLOCK: do while true: assign l-ml_nr = next-value(next-ml_nr). find...

Thank you for your answer. I will check triggers as soon as I will be back in the office. But anyway, it cannot be a problem of the triggers. The problem appears since a 2 days, before it worked for years...

create table_xy. assign field1 = "a". assign field2 = "b". running this, the client doesn't respond anymore. The problem appears only in one table. I think (...) that the problem is somewhere in sequences.

Hello Experts I have a problem creating a new record in one table. At the moment, the next sequence number should be shown, nothing happens anymore. The client is not responding, the process 'prowin32.exe' is consuming a log of processor-capacity. The problem appears only in one table. Does...

Thank you Greg. Are dynamic queries already available in 9.1D?

I have the following problem using Progress 9.1D: I have a variable (f.e. l-field1) which contains a field-name. Now, I have to assign a value to this field. Of course assign l-field1 = xyz assigns the value to the variable instead of the field. How to assign the value to the field? Or is...

Hello again Sorry for the late answer. I had a lot of other things to do. I added many indexes for tests but the procedure takes nearly the same time like before. In the code temp-tables and buffers are used very often. Are indexes used in temp-tables and buffers?

Thank you for your reply. Is this LISTENING option already available in 9.1d?

Hello There's a procedure, which replaces all user-IDs (f.e. user1 to user2). This procedure is very old and the dev is not available anymore. Now, I should make this procedure much faster. I did some changes, but I think that I have to add some more indexes now. I know which tables need much...

Re: Urgent problem with 'The total length of the fields in an index exceeds max key s I found the problem. The import has 2 steps. First the data are loaded to a temporary table (real table, no temp-table), in the second step the data are loaded to the final table. In this temporary table were...

Re: Urgent problem with 'The total length of the fields in an index exceeds max key s Thank you very much for your reply. It cannot be a problem of the csv-file. As I wrote, I'm able to import this file into a copy of this database (a few months old) without any problem. Sure I know in which...

Hello Experts I habe a very urgent problem with a software developed and running on Progress 9.1d. It worked well for years. Last week, an import interface reports the following error-message and quits: "The total length of the fields in an index exceeds max key size. (129)" I can import the...