Kbase P113854: Error 82 and 7341 with an SDO using joined tables from multiple databases.
Autor |
  Progress Software Corporation - Progress |
Acesso |
  Público |
Publicação |
  01/03/2006 |
|
Status: Unverified
FACT(s) (Environment):
Dynamics
Dynamics 2.1B
SYMPTOM(s):
Error 82 and 7341 with an SDO using joined tables from multiple databases.
Dynamic SDO update fails with error 82 and 7341. This is not a problem for static SDO's.
Joining tables from separate database can result in Dynamics errors 82 and 7341.
Only fields from the updatable tables in one database are included in the SDO.
** Starting position for SUBSTRING, OVERLAY, etc. must be 1 or greater. (82)
Invalid rowid for FIND-BY-ROWID method of BUFFER object <name>. (7341)
CAUSE:
This is a known issue being investigated by Development
FIX:
Add at least one field from the first Read Only database table to the SDO, or use a static SDO.
Alternatively, in an initializeObject override in the SDO, before RUN SUPER, prepend the database name to the table names in the SDO "tables" property.