You can access a property from a query result in two ways:
For example, you can query for an object's name using the query language property SI_NAME, and then use the InfoObject object's Title property to retrieve it.
Name = QueryResult.Item(Index).Title
Most SchedulingInfo properties can be accessed through the SchedulingInfo Object, and most ProcessingInfo object properties can be accessed through the Report Object.
ParentFolder = QueryResult.Item(Index).Properties.Item("SI_PARENTID")
Use the SchedulingInfo object's Properties property if you want to access a property in the SchedulingInfo property bag, and use the ProcessingInfo object's Properties property if you want to access a property in the ProcessingInfo property bag. For example, SI_SUBMITTER can be accessed only through the SchedulingInfo object's Properties collection:
Submitter =
QueryResult.Item(Index).
SchedulingInfo.Properties.Item("SI_SUBMITTER")
Note: To set a name or value for items in the Properties collection, use the Name Property and Value Property. You do not have to use these properties to get a name or value for objects in this collection.
Crystal Decisions, Inc. http://www.crystaldecisions.com Support services: http://support.crystaldecisions.com |