SET PROPERTYNAME
Note
Indexing Service is no longer supported as of Windows XP and is unavailable for use as of Windows 8. Instead, use Windows Search for client side search and Microsoft Search Server Express for server side search.
The SET PROPERTYNAME statement associates a property set with a friendly name (column alias) and a data type for the duration of an active connection. The property is identified by a GUID and a property ID, which can be either a number or a string.
SET PROPERTYNAME 'GUID' PROPID {'Property_Name' | Property_ID}
AS Friendly_Name [TYPE dbtype]
Parameters
-
GUID
-
Specifies the globally unique identifier (GUID). The GUID must be written in the following format, enclosed in single quotes:
- One 8-hex-character sequence, followed by a minus sign
- Three 4-hex-character sequences, each followed by a minus sign
- One 12-hex-character sequence
-
Property_Name
-
Specifies the name of the property within the ActiveX property namespace.
-
Property_ID
-
Specifies the property ID as a decimal or hexadecimal number. If you use a hexadecimal number, precede the number with "0x".
-
Friendly_Name
-
Specifies the friendly name (column alias). It is possible to set different (multiple) friendly names to the same property. For example, the friendly name "author" may be also known as "auteur" in a community where both English and French are spoken. However, it is important to note that these two friendly names cannot be used in the same query.
-
dbtype
-
Specifies the type of data being used. The dbtype parameter is optional for Indexing Service. You need to specify the parameter in situations when the data type is not a string, which is the default. For example, in the following piece of code, Indexing Service needs to know whether to interpret the value as a string or a date:
WHERE MyProperty = '1996-10-10'If the data type is not provided, DBTYPE_WSTR (Unicode string) is assumed. See Names Section of .Idq Files for further information.
Remarks
After a property name has been used in a view, it cannot be redefined.
Example
The following is an example of the SET PROPERTYNAME statement.
SET PROPERTYNAME 'D5CDD502-2E9C-101B-9397-08002B2CF9AE' PROPID 0xE AS DocManager
Related topics