AddRowEx Method

Description

Used in FetchData event to load data into DynamiCube when used in unbound mode. Rows are added into the array using a single dimensional array of variants.

Syntax

Public Sub AddRowEx( _
   ByVal Record As Variant _
)

Parameters

Record
Variant array of dimension values matching the order and number of dimensions and data fields.

Remarks

The size and order of the array and its elements should match the number of dimensions and data items used in the DynamiCube view and the order in which they were added into the view. The difference between AddRow and AddRowEx is that AddRowEx allows duplicate records to be fed into DynamiCube, automatically aggregating them into a single record. This is useful when the data is not pre-summarized. Note that AddRowEx has a slower performance than AddRow due to the additional work it does.

Example

[AddRowEx method (Visual Basic)] 

Private Sub DCube1_FetchData()
       DCube1.AddRowEx Array("Data Field 1", Null)
       DCube1.AddRowEx Array("Data Field 2", 1)
End Sub

See Also

DCube Control

 

 

Copyright © 2007 Data Dynamics, Ltd. All rights reserved.