>Hi All,
>
>What is the VFP equivalent to VB's array assignment to PivotTable COM object?
>
>E.g. (VB):
>
>thisform.PivotTable.ActiveView.FieldSets("Store").Fields("Store
>State").FilterMembers=Array("11","22").
>
>
>Is there any way to make it work?
>
>Thanks,
>Andy
Andy,
Most likely this is not translatable. The ActiveX control is probably looking for a SafeArray and VFP doesn't create those. If there is a method that accepts an array and assigns the passed array to Array property, you can probably use George's suggestion of COMARRAY(). However, if there is no method and the property expects an array assignment then you can't do it in VFP.
While not having used this control, I have experienced this same problem using ADSI. The Filter property of that COM object also wants a SafeArray.
Larry Miller
MCSD
LWMiller3@verizon.netAccumulate learning by study, understand what you learn by questioning. -- Mingjiao