This Tech Note documents a 4D v11 SQL component that provides a host database with an enhanced library of over 45 array management and manipulation methods. The component includes routines for sizing arrays, inserting elements, converting between types of arrays, parsing of values into arrays, counting values within a range, sort matching, "Set Theory" for arrays, and array statistics, to name a few. The demo database will demonstrate how to use these routines in 4D v11 SQL.

Download Complete Tech Note and Example: Windows | Mac