Question Break By 10 Character Fields

[moonhkt-o]

Hi All
Any method to solve below issue ?
0141 ** Index value is too long. (141)

I have program sort more than 8 character fields(Address fields each fields max 40 characters), A runtime error found.

Progress : 8.X

moonhkg

 

[Osborne]

See if the solutions here help:

break by 'character field'

However, unless you can upgrade the Progress version there is likely nothing you can do:

Progress KB - What are the size limits for indexing and sorting?

 

[tommartinson]

Two cheesy solutions:
1) Sort one temp-table into another multiple times until you have "boiled down" the sort you need.
2)Output your fields into a text file with keys and rowid, then use unix sort and load that back in.

(replace rowid with recid and temp-table with workfile if necessary, I don't remember if these both existed in version 8!)

I am ashamed to admit I used #2 many years ago and it was faster than I would have guessed.