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

See also

DB.scope

DB.sort

DB.AppendFinish