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