Consultor Eletrônico

SUMMARY:

This Solution provides 2 ways to solve the error:

Record ID is larger than <max-recid>. (2090)

This error might appear when accessing or inserting data into a foreign database through the ODDBC (for instance, Informix) or MS SQL Server DataServer in Progress Version 9.1C and earlier.

EXPLANATION:

This error message occurs when tables do not contain any PROGRESS_RECID column and the indexes are composed of more than 7 fields.

A record retrieval in a table without a RECID column, results in all of the index fields being passed back to the client. Therefore with many Index fields the allocated buffer may reach its maximum length.

SOLUTION:

The solution choices are:

-- Reduce the number of index fields.

- or -

-- Add a PROGRESS_RECID column.
Thus Progress just passes back the single RECID column.


If you are working with a third-part Database. You might want to change the index associated with the ROWID in the schema holder (Data dict -> table properties -> dataserver).


NOTE: After applying changes in the foreign database, be sure to update your schema holder.


References to Written Documentation:

Progress DataServer for ODBC Guide
Progress DataServer for Microsoft SQL Server Guide