Kbase P156542: How to load MAX-WIDTH in df file and have it adjusted automatically based on the modified format siz
| Autor |
Progress Software Corporation - Progress |
| Acesso |
Público |
| Publicação |
11/26/2009 |
|
Status: Unverified
GOAL:
How to load MAX-WIDTH with a df file and have it adjusted automatically based on the modified format size?
GOAL:
How to load SQL-WIDTH with a df file and have it adjusted automatically based on the modified format size?
GOAL:
Is there an easy way to correct the MAX-WIDTH settings when there are many fields that have had their format size changed, but the data has not been expanded?
GOAL:
Is there an easy way to correct the SQL-WIDTH settings when there are many fields that have had their format size changed, but the data has not been expanded?
FACT(s) (Environment):
All Supported Operating Systems
Progress 9.x
OpenEdge 10.x
FIX:
By dropping the MAX-WIDTH line from the field where the format has been modified, the MAX-WIDTH will automatically be adjusted to the proper value during the load of the .df file.
The following is an example of a field that was modified and the format was changed, but the MAX-WIDTH was not prior to dumping the .df file:
ADD FIELD "Name" OF "Customer" AS character
FORMAT "x(50)"
INITIAL ""
LABEL "Name"
POSITION 3
MAX-WIDTH 80 <------ This line will set MAX-WIDTH to 80 which is incorrect for a format value of 50.
HELP "Please enter a name."
ORDER 30
By removing the MAX-WIDTH line from the .df, the MAX-WIDTH settings will be automatically adjusted at load time.
ADD FIELD "Name" OF "Customer" AS character
FORMAT "x(50)"
INITIAL ""
LABEL "Name"
POSITION 3
HELP "Please enter a name."
ORDER 30