Difference between revisions of "DBRELATION()"
From Recital Documentation Wiki
Yvonnemilne (Talk | contribs) |
Yvonnemilne (Talk | contribs) |
||
| (4 intermediate revisions by 2 users not shown) | |||
| Line 1: | Line 1: | ||
| − | |||
| − | |||
| − | |||
| − | |||
==Purpose== | ==Purpose== | ||
Function to return table-linking expression | Function to return table-linking expression | ||
| Line 12: | Line 8: | ||
==See Also== | ==See Also== | ||
| − | [[CREATE BRIDGE]], [[CREATE VIEW | + | [[CREATE BRIDGE]], [[CREATE VIEW]], [[DBRSELECT()]], [[RELATION()]], [[SET RELATION]], [[SET VIEW]], [[TARGET()]], [[USE]] |
==Description== | ==Description== | ||
| − | The DBRELATION() function is synonymous with the RELATION() function. The DBRELATION() function returns the linking expression of a specified relation in the current workarea. The <expN> specifies the position of the desired linking expression from the list of previously defined relations | + | The DBRELATION() function is synonymous with the RELATION() function. The DBRELATION() function returns the linking expression of a specified relation in the current workarea. The <expN> specifies the position of the desired linking expression from the list of previously defined relations. The DBRELATION() function always returns a character string in lower case. If there is no linking expression defined for the <expN> selected a null string will be returned. |
| Line 24: | Line 20: | ||
use patrons in 1 | use patrons in 1 | ||
set relation to patron_code into shows | set relation to patron_code into shows | ||
| − | ? | + | ? dbrelation(1) |
patron_code | patron_code | ||
? target(1) | ? target(1) | ||
| Line 32: | Line 28: | ||
==Products== | ==Products== | ||
| − | Recital | + | Recital Server, Recital |
[[Category:Documentation]] | [[Category:Documentation]] | ||
[[Category:Functions]] | [[Category:Functions]] | ||
Latest revision as of 16:53, 15 December 2009
Purpose
Function to return table-linking expression
Syntax
DBRELATION(<expN>)
See Also
CREATE BRIDGE, CREATE VIEW, DBRSELECT(), RELATION(), SET RELATION, SET VIEW, TARGET(), USE
Description
The DBRELATION() function is synonymous with the RELATION() function. The DBRELATION() function returns the linking expression of a specified relation in the current workarea. The <expN> specifies the position of the desired linking expression from the list of previously defined relations. The DBRELATION() function always returns a character string in lower case. If there is no linking expression defined for the <expN> selected a null string will be returned.
Example
use shows in 2 index pcode use patrons in 1 set relation to patron_code into shows ? dbrelation(1) patron_code ? target(1) 2
Products
Recital Server, Recital
