Kbase P83575: Exporting data from a table and the character fields have blank spaces at the end
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
2/3/2009 |
|
Status: Verified
SYMPTOM(s):
Exporting data from a table and the character fields have blank spaces at the end
FACT(s) (Environment):
Progress 8.3x
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
OpenEdge Category: Language (4GL/ABL)
CAUSE:
The EXPORT statement will write out whatever the contents of the field are (including spaces at the end). Since the application itself has written the spaces to the database the 4GL has no automatic way to determine that they can be safely removed so consequently is forced to leave them.
FIX:
Wrap the TRIM() function around the character fields in the EXPORT statement which have extra spaces at the end