Stonefield Query makes extensive use of collections of objects. For example, the Fields collection is a collection of Field objects, each one of which represents a field in a table in one of the databases of the application. All collections are derived from a collection class, so they all have the same properties and methods (although some collections may add additional properties and methods as needed).

Note that collections do not support the FOR EACH construct and must be iterated using the Count property and Item method, such as:

for I = 1 to Collection.Count
   Object = Collection.Item(I)
next

Properties

Name	Data Type	Description
Count	Numeric	The number of objects in the collection.
ErrorMessage	String	The text of any error that occurs.

Methods

Name	Description
AddItem	Returns a new member object.
Clear	Removes all items from the collection.
Item	Returns a member of the collection.
RemoveItem	Removes a member of the collection.

See Also
Databases Collection | DataSources Collection | Fields Collection | FilterConditions Collection | Joins Collection | Parameters Collection | Tables Collection | Users Collection