Using SelectTo* Methods 

The SelectTo* methods provide a special view of the table (like a dejoin). These methods return all table data that satisfies value specifications for certain table dimensions.

In the example below, the SelectTo method returns a two-dimensional view of one column of a table. Suppose the desktop application requests data from a particular table column (the "desired-data" column), where the values to be selected depend on values in two other ("key-value") columns of the table. The desktop program specifies the values in the "key-value" columns when calling the SelectTo method:

Calling programs can request data by specifying either one or two input vectors. To specify values using: