Kbase 15619: error 2090 and row identifier
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
5/10/1998 |
|
error 2090 and row identifier
You may get error 2090:
Record ID is larger than <max-recid>. (2090)
when creating or updating a record.
"The maximum allowed length of a row identifier is 255 bytes".
The row identifier is the name of the fields part of the primary key
plus the value for these fields.
Have: CREATE table1.
key_field1 = 10000.
key_field2 = "value".
key_field_too_long_name = "very_long_string_xxxxxxxxxxx".
which generates an error 2090.
There are two options.
OPTION1: Rename one of the key_field*
OPTION2: Shorten the value of a CHAR field.
Would work:
CREATE table1.
key_field1 = 10000.
key_field2 = "value".
key_field3= "very_long_string_xxxxxxxxxxx".
or
CREATE table1.
key_field1 = 10000.
key_field2 = "value".
key_field_too_long_name= "shorter_string".
Progress Software Technical Support Note # 15619