Kbase P29286: Error 10481 when compiling a program containing the ROWID function against a MS SQL Server database
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
6/17/2005 |
|
Status: Verified
FACT(s) (Environment):
MS SQL Server DataServer
ODBC DataServer
SYMPTOM(s):
Error 10481 when compiling program containing the ROWID function
The 4GL statement to be executed requires a RECID. No RECID was selected for the table. (10481)
** Could not understand line 2. (196)
The Progress table has been created by the Migration Tool from the Data Administration
When migrating the "Create RECID Field" option has not been selected
CAUSE:
The primary index has not been created with the ROWID support.
FIX:
To not receive the error 10481 any more, enable the ROWID support for the primary index by following the steps below:
1- Connect to the schema holder from the data Dictionary
2- Select the primary index and open its property by double-clicking on it
3- Check the ROWID property
4- From the Data Administration, update the schema holder.
If the step #4 is not performed, the error 10481 will still occur.