Kbase 22014: Dynamics: Table Name with > 28 Characters Gives Error (1700)
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
06/05/2002 |
|
SUMMARY:
This Solution describes a problem you might encounter in Progress Dynamics with tables that have names longer than 28 characters.
EXPLANATION:
When Dynamics creates the SDO and logic procedure, in the Generate Objects utility, two buffers are created for the table the SDO is being built for. The naming convention for these buffers is to add prefixes of:
b_<table-name>
- and -
old_<table-name>
If the table name is greater than 28 characters, when the second prefix is added, the buffer name will be more than the 32-character limit and you will get error 1700 during the generation of the SDO.
The generation of the SDO will fail.
Identifier was left blank or is more than <maximum> characters.
(1700)
SOLUTION:
The table name must be 28 characters or less.