Salesforce

How to load MAX-WIDTH in df file and have it adjusted automatically based on the modified format size?

« Go Back

Information

 
TitleHow to load MAX-WIDTH in df file and have it adjusted automatically based on the modified format size?
URL NameP156542
Article Number000131665
EnvironmentAll Supported Operating Systems
Progress 9.x
OpenEdge 10.x
Question/Problem Description
How to load MAX-WIDTH with a df file and have it adjusted automatically based on the modified format size?
How to load SQL-WIDTH with a df file and have it adjusted automatically based on the modified format size?
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?
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?
Steps to Reproduce
Clarifying Information
Error Message
Defect Number
Enhancement Number
Cause
Resolution
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
Workaround
Notes
NOTE:  Normally dbtool menu item 2 can be used to automatically adjust the MAX_WIDTH, however, this is based on data width, not the format value.

Reference Solution P115986: "Does dbtool automatically increase the SQL-Width of a field if i change the display format?" for additional information.

Keyword Phrase
Last Modified Date9/13/2015 3:50 PM

Powered by