Product.Variants

Ee797904.c++_on(en-US,CS.10).gifEe797904.vb_off(en-US,CS.10).gif

The Variants property is a read-only recordset that describes all of the variants of this product.

Definition

Property Variants(Optional strPropertyToSortOn As Variant) As Recordset

Parameters

strPropertyToSortOn

A Variant that contains the property on which the returned Recordset object is to be sorted.

Error Values

This method sets the Number property of the global Err object to S_OK (&H00000000) to indicate success and to standard COM error values to indicate failure. For more information about standard COM errors, see Standard COM Errors. Additional information may be available using the global Err object. In particular, the Description property may contain a text description of the error.

Remarks

If this product has no variants, the returned recordset will be empty, and its EOF property will be set to VARIANT_TRUE.

The recordset returned contains fields for all of the properties defined for variants of this product and the following fields:

Field Type Description
TimeStamp Timestamp None
cy_list_price Currency List price
<defined variant ID> Varies None

For more information about memory ownership issues related to COM property and method parameters, see Managing COM Parameter Memory.

Example

SET rsVariants = myProduct.Variants("Size")

See Also

Product Object


All rights reserved.