Oninit
Talk to an expert →

Informix Error -4423: The CLIPPED and USING options for the DISPLAY statement may not be used when displaying to a form field.

Cause and resolution

The CLIPPED and USING options for the DISPLAY statement may not be used when displaying to a form field.

The CLIPPED and USING keywords cannot be used in the DISPLAY TO and DISPLAY BY NAME statements. The display format of a form field is controlled by the attributes of that field, as specified in the form file. Trailing spaces are not displayed in a field. To get the effect of USING, edit the form file and add a USING attribute to the field or fields.

Oninit® Troubleshooting Guidance

Reasons / Common Causes

-4423 fires when CLIPPED/USING is used with DISPLAY TO/DISPLAY BY NAME — per the official guidance, a form field's display format is controlled by its own attributes in the form file, and trailing spaces aren't displayed in a field regardless.

  1. CLIPPED/USING used in a DISPLAY TO/DISPLAY BY NAME statement, per the official guidance — the direct, only cause.
Solutions / Resolution
  1. Remove CLIPPED/USING from the DISPLAY TO/DISPLAY BY NAME statement.
  2. To get the effect of USING, add a USING attribute to the field in the form file instead, per the official guidance.
Examples
USING in a DISPLAY TO statement
DISPLAY price USING "###.##" TO fld_price
-- -4423: USING isn't valid with DISPLAY TO
Corrected
ATTRIBUTES
  fld_price = unit_price, FORMAT = "###.##";

DISPLAY price TO fld_price
Diagnostic Checks
  1. Check every DISPLAY TO/DISPLAY BY NAME statement for CLIPPED/USING, and remove it, adding a USING/FORMAT attribute to the field in the form file if that effect is needed.
Related Errors / Related Topics

No closely related error codes are cross-referenced for -4423 in this set yet.

CLIPPED/USING is used with DISPLAY TO/DISPLAY BY NAME — remove it and set the field's formatting attribute in the form file instead.