Kbase 19171: Undefined data type associated with column . (1699)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
15/10/2008 |
|
Status: Verified
FACT(s) (Environment):
Progress 8.X
Progress 9.X
SYMPTOM(s):
Undefined data type <type_number> associated with column <column>. (1699)
Error using Raw Datatypes in Report Builder.
CAUSE:
RAW data type fields in a table are unusable to Report Builder. The RAW data type is an undefined data type for all intents and purposes, and if you try to use Report Builder with a table that has a RAW data type field, it returns the following Error 1699:
Undefined data type <type_number> associated with column <column>. (1699)
An undefined data type was associated with a column in a fetch request from a dynamically opened cursor. Make sure that any changes to the data types in the SQLDA are data types as defined in the include file proesql.h.
FIX:
The error can be created with the following steps:
1) Run the Data Dictionary and connect to the Sports Database.
2) Create a field in the Customer table with the RAW data type.
3) Open Report Builder and connect to the Sports Database.
4) Select the Customer table from the table selection list.
The error is a SQL-89 limitation that prevents access altogether to that table in the RB tool.