Register
Sign In
ad hoc relationshipConcept
Purpose
Like a predefined relationship, an ad hoc relationship is a relationship between two sets of records, but an ad hoc relationship is created as a script is processed instead of being specified on the Relationships form during the Form Definition process. An ad hoc relationship lets you easily access records in another table while processing a procedure. However, because the ad hoc relationship isn't stored as a part of the database, it must be redefined in each procedure.
An ad hoc relationship is created by combining a relational (or relational statistical) operator with the name of an unrelated table, or the name of a predefined relationship to which new selection criteria are added.
When you create an ad hoc relationship, the named operator is used to give the set of related records a unique name. This lets DataEase identify each distinct set of records selected from a given table.
Unlike predefined relationships, ad hoc relationships can also include comparisions based on a rage, such as Âbetween Current Date  60 to Current DateÂ, as well as fields where the values are not equal.
Syntax
relational operator TABLENAME
Product: . Written by alembagheri tahmas 07/12/13 at 13:37:32
Product: DataEase for Windows 7.x. Written by George Washington 11/04/14 at 08:26:17
Product: DataEase 8 Reporter. Written by eduardo paez 02/05/14 at 14:40:11
Product: . Written by Marco Marchesi 15/02/16 at 14:50:46
Product: Dataease [{8}]FIVE. Written by Chamil Rajindra 21/02/19 at 10:17:46
Product: . Written by afonso santos 28/10/19 at 00:50:14
Product: . Written by Grossi Gioacchino 18/11/19 at 14:33:44
Product: Dataease [{8}]FIVE. Written by Rainer 22/03/21 at 11:13:10
Product: Dataease [{8}]FIVE. Written by Rainer 08/06/21 at 14:12:40
Product: . Written by Hiralal Rampul 01/12/21 at 17:47:10
Copyright © DataEase Limited. All Rights Reserved
