<div>
<div class="content wysiwyg-content">
I'm getting an error:<br />
<br />
&quot;The total length of the fields in an index exceeds max key size&quot;<br />
<br />
when trying to create a temp table record in my code. &nbsp;I've tracked the error down to an index on the temp table that I'm creating a record for. &nbsp;I found the exact record that's causing the issue and if I add up all of the characters in all of the fields in the index, if it's over 172, then I get this error, if it's 172 or less, it works just fine. &nbsp;What is the character limit for an index record? &nbsp;I've found 180 and I've found 200. &nbsp;Can this be adjusted in my current version of Progress? &nbsp;Or do I have to upgrade to 10.1b?
</div>
</div>


I'm getting an error:

"The total length of the fields in an index exceeds max key size"

when trying to create a temp table record in my code.  I've tracked the error down to an index on the temp table that I'm creating a record for.  I found the exact record that's causing the issue and if I add up all of the characters in all of the fields in the index, if it's over 172, then I get this error, if it's 172 or less, it works just fine.  What is the character limit for an index record?  I've found 180 and I've found 200.  Can this be adjusted in my current version of Progress?  Or do I have to upgrade to 10.1b?

What is the index record size limit on a Progress 10.0b database temp table?

Databases are organized collections of data, most commonly accessed through management systems including schemas, tables, queries and processes that allow users to enter and manipulate the information or utilize it in other fashions, such as with web applications or for reporting purposes.