Analyse table for MAX length

Analysing the actual maximal length of text, memo and Bytes data in a table

For practical data handling it may be convenient to know the actual maximal length of all text fields as well as Memo and FmtMemo fields in a table and not just the allocated field sizes.

This is implemented in PdxEditor in a universal compound SQL* procedure that can be called for any table currently displayed in the data grid.
The procedure is called via the Table menu by [Analyse Table for Max Data Length ...].

MaxLength

*: actually using a third party in memory module with the capacity of handling the SQL LENGTH(column_reference) function,
as the necessary LENGTH() function is not provided by BDE Local SQL.