ADO » Properties » Count
The Count property returns a long value that is the number of items in the collection. The counting starts at zero. You can use this value to loop through the collection by iterating from zero to the value of Count minus one.
Examples
Code:
intCountNumber = objCommand.Properties.Count
Code:
For Each objProperty In objCommand.Properties
' place code here to manipulate each item in collection
Next
Explanation:
You can also use the VB/VBScript For Each ... Next statement.
