[Stackoverflow] [Progress OpenEdge ABL] How to determine the largest length of Progress 4GL fields

Status
Not open for further replies.
Z

zarose

Guest
In OpenEdge / Progress 4GL, a field can be defined with a FORMAT, but that is only the default format for it to be displayed. Thus, a CHARACTER field with FORMAT 'X(10)' could store thousands of characters past the first ten.

The database I'm using contains millions of rows in some of the tables I'm concerned with. Is there any system table or Progress-internal program I can use to determine the longest length of a given field? I'm looking for anything more efficient than full-table scans. I'm on Progress 11.5.

Continue reading...
 
Status
Not open for further replies.
Top