Kbase P138285: Error 12393 when navigating through ABL data browser upward using OpenEdge 10 ODBC DataServer
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/01/2009 |
|
Status: Unverified
SYMPTOM(s):
Error 12393 when navigating through ABL data browser upward using OpenEdge 10 ODBC DataServer
Cannot LAST or PREV Query <name> when FORWARD-ONLY or -noautoreslist enabled. (12393)
Cannot LAST or PREV Query br-qry when FORWARD-ONLY or -noautoreslist enabled (12393)
FACT(s) (Environment):
The OE 10 ODBC DataServer is connecting to DB2/400 Database
The table does not have any unique index that can be associated with progress recid
Windows
OpenEdge 10.1x
OpenEdge 10.2x
ODBC DataServer
IBM DB2 Universal Database
OS/400 V5R4
CAUSE:
No unique index on the DB2/400 table
FIX:
Create unique SQL index and delete and pull the table back to the schema holder using Data Administration > DataServer > ODBC Utilities > Update/Add Table Definition... tool