IRdsAttribute.Query

Syntax

Query: String;

Description

The Query property determines text of the query, which is used to calculate value of calculated attribute.

Comments

To determine whether the attribute is calculated, use the IRdsAttribute.Calculated property.

You can use the #TABLE# mask in the query text, on executing the query this mask is replaced with name of a table of a table MDM dictionary. The query is not checked for correctness.

For example: select t1."KEY" from test1_data.T2522 t1 where t1."KEY"=#TABLE#."KEY".

If the query contains main table fields and borrowed fields, the #TABLE# mask should be used before the main fields.

Example

The property use is given in the example for IRdsAttribute.Calculated.