DB.GetValues

Description

Returns an array of values for the field(s) specified in the input parameter. The return value is an array of arrays if the input parameter contains multiple fields and a single array if the input parameter is a single field. This method does not need a prior call to Select method. The return values are taken from all records in the record set.

Syntax

Function GetValues(field_name|Array(term_name,...))

Parameters

field_name|Array(term_name,...)) (input) - you can input a single field to get a value, or an array of fields to get the values from each.

Return value

variant - it will return a single value, or an array of values depending on the parameters

Example

Sample code

Dim values, f1, f2, f3

DB.Scope.Set( "Field1 > 1000" )

values = DB.GetValues( Array( "Field1", "Field2", "Field3" ) )

f1 = values(0)

f2 = values(1)

f3 = values(2)

sum = f1(0) + f2(0) + f3(0) 'sum has a total value of the three field values from the first record