GroupedValues (open)

Return grouped values as an array

Syntax

// Core function, no LOADLIB necessary

VARIANT FUNCTION GroupedValues(VARIANT data)

Parameters

VARIANT data

Data to gather

Return value

VARIANT

The gathered values as an array

Examples

// Show folder names along with a list of files in that folder
  SELECT folders.name, filenames := GroupedValues(files.name)
    FROM files, folders
   WHERE folders.parent = somefolder
         AND files.parent = folders.id
GROUP BY folders.name