X
XLate(expC1,expC2,expV,expC3)
Data Format Returned: X
Queries an alias or table based on a specified qualifying expression and returns a value from that alias/table corresponding to a specified expression.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | Name of alias or table name containing expression to retrieve. This can be the name of an alias already in use, or can point to a physical table name, in which case the alias name does not have to be in use. |
expC2 | Required | Expression from alias or table name used to qualify records. This can be a single field name or compound field expression. |
expV | Required | Value used
to compare field expression. Xlate will return
the record where the field name or expression specified in expC2
matches this value.
|
expC3 | Required | Expression to return. If a record is found in expC1 based on qualifying expression in expC2, then expC3 is evaluated against the first record found and its value is returned. |
XLateSeq(expC1,expC2,expC3,expN1,expC4,expN2)
Data Format Returned: X
Queries an alias or table based on a specified qualifying expression, record sequence number, and a filter and returns a value from that alias/table corresponding to an expression you specify.
Parameters
Variable | Status | Description |
---|---|---|
expC1 | Required | Name of alias or table name containing expression to retrieve. This can be the name of an alias already in use, or can point to a physical table name, in which case the alias name does not have to be in use. |
expC2 | Required | Qualifying expression. Only the records which meet this criteria are considered. Normally, this expression should identify a set of child records that relate to one parent record. |
expC3 | Required | Expression to return. If records are found in expC1 based on the qualifying expression in expC2, then expC3 is evaluated against the record specified by expN1, expC4, and expN2 and its value is returned. |
expN1 | Required | Specifies that expC3 should be evaluated against the expN1th record in the query result set. |
expC4 | Required if expN2 is specified, otherwise Optional | Limits the records considered for expN1 to those for which expC4 evaluates to true. |
expN2 | Optional | Limits the records considered for expN1 to all those that match expC2 except the first expN2 that also match expC4. |