Information

Title	Does changing the SQL-Width impact the table and index CRC value?

URL Name	P10811

Article Number	000149597

Environment	All Supported Operating Systems Progress 9.x OpenEdge 10.x

Question/Problem Description

Does changing the SQL-Width by applying a delta df file impact the table and index CRC value ?
Is it necessary to recompile r-code after changing the SQL-Width
also called MAX-WIDTH in the delta df file?

Steps to Reproduce

Clarifying Information

Error Message

Defect Number

Enhancement Number

Cause

Resolution

Changing the SQL-Width or MAX-WIDTH will not change the CRC.

The SQL-Width (_field._width) is not used by the 4GL layer, and it is not referenced as a component in the CRC calculation.

The attached example delta.df file can be used to demo the behavior with the sports2000 database.

Workaround

Notes

References to Written Documentation

Progress Solution:
20008, "ODBC/JDBC Errors Caused by Incorrect SQL Width"

Keyword Phrase

Last Modified Date	9/13/2015 5:20 AM

Does changing the SQL-Width impact the table and index CRC value?

Information