Product.Variants
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")