Kbase P121476: Getting error 11408 opening a Smart Data Viewer in AppBuilder
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
05/01/2007 |
|
Status: Unverified
FACT(s) (Environment):
OpenEdge 10.1A
OpenEdge 10.0B
SYMPTOM(s):
Getting error 11408 opening a Smart Data Viewer in AppBuilder
<fieldname> is a BLOB or CLOB field that is not allowed in an undoable temp-table (11408)
A new field CLOB was added to the supporting Smart Data Object
CAUSE:
RowObject defined in Smart Data Viewer without NO-UNDO option
FIX:
Open the Viewer in the Procedure Editor and manually add NO-UNDO option to the RowObject define statement and Procedure Settings section.
The code should look like:
/* Temp-Table and Buffer definitions */
DEFINE TEMP-TABLE RowObject NO-UNDO
{"dTable.i"}.
...
/* *********************** Procedure Settings ************************ */
&ANALYZE-SUSPEND _PROCEDURE-SETTINGS
/* Settings for THIS-PROCEDURE
Type: SmartDataViewer
Data Source: "ddept.w"
Allow: Basic,DB-Fields,Smart
Container Links: Data-Target,Update-Source,TableIO-Target,GroupAssign-Source,GroupAssign-Target
Frames: 1
Add Fields to: Neither
Other Settings: PERSISTENT-ONLY COMPILE
Temp-Tables and Buffers:
TABLE: RowObject D "?" NO-UNDO
ADDITIONAL-FIELDS:
{dTable.i}
END-FIELDS.
END-TABLES.
*/