Difference between revisions of "SET WINDOW OF RELATION"

From Recital Documentation Wiki
Jump to: navigation, search
 
(4 intermediate revisions by 2 users not shown)
Line 1: Line 1:
=SET WINDOW OF RELATION=
 
 
 
==Class==
 
Screen Windows
 
 
 
 
==Purpose==
 
==Purpose==
 
Activate a relational window
 
Activate a relational window
Line 12: Line 5:
 
==Syntax==
 
==Syntax==
 
SET WINDOW OF RELATION [IN <alias>] TO [<window-name>]
 
SET WINDOW OF RELATION [IN <alias>] TO [<window-name>]
[COMMAND EDIT | BROWSE [<qualifier>]
+
 
|DO <procedure | program>]
+
[COMMAND EDIT | BROWSE [<qualifier>] | DO <procedure | program>]
  
  
 
==See Also==
 
==See Also==
[[BROWSE]], [[DEFINE WINDOW]], [[EDIT]], [[SET WINDOW OF BROWSE]], [[SET WINDOW OF EDIT]], [[SET WINDOW OF MEMO]]  
+
[[BROWSE]], [[DEFINE WINDOW]], [[EDIT]], [[Function Keys]], [[INDEX]], [[SET INDEX]], [[SET ORDER]], [[SET RELATION]], [[SET WINDOW OF BROWSE]], [[SET WINDOW OF EDIT]], [[SET WINDOW OF MEMO]], [[USE]]
 +
 
  
 
==Description==
 
==Description==
Line 36: Line 30:
  
 
==Example==
 
==Example==
 
+
<code lang="recital">
<pre>
+
 
set view to demo
 
set view to demo
 
set window of relation in accounts to brelation;
 
set window of relation in accounts to brelation;
command browse
+
  command browse
 
set window of relation in product to bedit;
 
set window of relation in product to bedit;
command edit
+
  command edit
 
set window of browse to rbrowse
 
set window of browse to rbrowse
 
browse noclear
 
browse noclear
</pre>
+
</code>
 +
 
  
 
==Products==
 
==Products==
Recital Terminal Developer
+
Recital  
 
[[Category:Documentation]]
 
[[Category:Documentation]]
 
[[Category:Commands]]
 
[[Category:Commands]]
 
[[Category:Set_Commands|WINDOW OF RELATION]]
 
[[Category:Set_Commands|WINDOW OF RELATION]]
 +
[[Category:Screen Windows]]
 +
[[Category:Screen Windows Set Commands]]

Latest revision as of 16:00, 25 November 2009

Purpose

Activate a relational window


Syntax

SET WINDOW OF RELATION [IN <alias>] TO [<window-name>]

[COMMAND EDIT | BROWSE [<qualifier>] | DO <procedure | program>]


See Also

BROWSE, DEFINE WINDOW, EDIT, Function Keys, INDEX, SET INDEX, SET ORDER, SET RELATION, SET WINDOW OF BROWSE, SET WINDOW OF EDIT, SET WINDOW OF MEMO, USE


Description

The SET WINDOW OF RELATION command activates a window to view and modify data that is related to an active BROWSE or EDIT window.

As the record pointer is moved through the BROWSE or EDIT window, data in <window> is refreshed to show only those records that are related to the parent table. The <window> must be defined with a DEFINE WINDOW command. The cursor may be moved into the related window by using the [FIND NEXT] key to cycle through all related windows. When the window is selected, any operation that is allows with the type of work surface may be used.

The optional IN <alias> qualifier may be used to specify the workarea that SET WINDOW OF RELATION is to work in. If this qualifier is not used, the appropriate workarea must be selected before the SET WINDOW OF RELATION command is issued.

Each workarea may have a SET WINDOW OF RELATION defined. It is required that the SET RELATION command be used to define the relations between the workareas before the SET WINDOW OF RELATION command is issued.

The COMMAND qualifier specifies whether data will be presented in a BROWSE or an EDIT work surface or if a program or procedure will be called. If BROWSE is specified, the related data will appear within the named window in a BROWSE work surface. If EDIT is used the first related record will be shown in an EDIT work surface. If DO is specified, the named program or procedure will be called.

The BROWSE or EDIT command may be customized with any qualifier, by using the <qualifier> option. For example, when specifying BROWSE, you might want to limit the number of fields with the FIELDS qualifier of the BROWSE command.

If the SET WINDOW OF RELATION command is issued without any qualifiers it will be deactivate the related window. To re-activate the related window, issue another SET WINDOW OF RELATION command.


Example

set view to demo
set window of relation in accounts to brelation;
  command browse
set window of relation in product to bedit;
  command edit
set window of browse to rbrowse
browse noclear


Products

Recital