DriveWorks Solo 15: ListAll [send feedback...]

Syntax

LISTALL( [ Table], [ Column] )

Retrieves all data cells from the specified column within the selected table, and returns as a list.

The Table is the table from which to retrieve the data.

Column is the number of the column within the table to retrieve the data from.

Examples

Rule

Meaning
LISTALL(Vehicles, 1)The function looks in the Vehicles table, and retrieves all the data in the first column (as specified by the user). In this case, that first column contains car makes, so the list; "Volkswagen|Ford|Renault|Mazda" is returned.

Example Outcomes

Table

Column

Outcome

Vehicles1"Volkswagen|Ford|Renault|Mazda"
People2"Dave Sharp|Joe Bloggs|Sandra Shields|Thomas Knight|Isabelle Jones"

Example Data

Vehicles Table

MakeModelColour
VolkswagenGolfBlue
FordEscortRed
RenaultKangooWhite
Mazda2Black

People Table

Member IDNameAgeGender
42Dave Sharp25Male
44Joe Bloggs37Male
96Sandra Shield42Female
107Thomas Knight21Male
251Isabelle Jones56Female

Table of Contents