The Query object represents a lookup list query to an external database. The Query object is available to the Vault object.
Query Object Properties
The Query object provides the following properties, all of which are read-only. To affect some read-only properties requires user interaction or custom event procedures.
DBConnection Property
An ADO connection object. Read-only.
Syntax
DBConnection As Object
DisplayName Property
The display name of the query as seen by users. Read-only.
Syntax
DisplayName As String
Name Property
Returns the name of the current object. Depending on the object type, this property returns the display name of the object or it returns the internal name and may be read-only.
Syntax
Name As String
Remarks
If the current object is a Package, it must be in the Open status to set the value.
If the current object is a User, this property is the short name of the user as stored in the user's Meridian account information and is read-only. This property can be used to specify the recipient's email address and either an empty string or no value set in the Address property. If an email address is specified in Name, it must be surrounded with carets (<>). When used with Microsoft Outlook, the Name property may contain the user's full name or last name and Outlook will attempt to resolve the name to the email address in the default address book.
Type Property
The type of the query as one of the AS_TQTYPE constants. Read-only.
Syntax
Type As AS_TQTYPE
Query Object Methods
The Query object methods affect the current Query object. They are described below.
GetValues Method
The GetValues method of the Query object is the same as the GetValues method of the Table object except that it operates on a Query object.
GetValuesEx Method
The GetValuesEx method of the Query object is the same as the GetValuesEx method of the Table object except that it operates on a Query object.