4D v14.3

SET FIELD RELATION

Home

 
4D v14.3
SET FIELD RELATION

SET FIELD RELATION 


 

SET FIELD RELATION ( manyTable | Field ; one ; many ) 
Parameter Type   Description
manyTable | Field  Table, Field in Starting table of relations or Starting field of a relation
one  Longint in Status of the Many-to-One relation starting from the field or the Many-to-One relations of the table
many  Longint in Status of the One-to-Many relation starting from the field or the One-to-Many relations of the table

The SET FIELD RELATION command sets the automatic/manual status of each relation of the database separately for the current process, regardless of its initial status as specified in the Relation properties window in the Design environment.

In the first parameter, pass a table or field name:

  • If you pass a field name (manyField), the command only applies to the relation starting from the specified Many field.
  • If you pass a table name (manyTable), the command applies to all the relations starting from the specified Many table.
  • If there is no relation starting from the manyField field or manyTable table, the syntax error No. 16 (“The field has no relation”) is generated and the system variable OK is set to 0.

In the one and many parameters, pass the values indicating the changing of the automatic/manual status to be applied respectively to the specified Many-to-One and One-to-Many relation(s). You can use the constants of the “Relations” theme:

  • Do not modify (0) = Do not modify the current status of the relation(s).
  • Structure configuration (1) = Use the configuration set for the relation(s) in the Structure window of the application.
  • Manual (2) = Makes the relation(s) manual for the current process.
  • Automatic (3) = Makes the relation(s) automatic for the current process.

Note: Changes made using this command only apply to the current process. The configuration of the relations set using the options in the Relation properties window is not modified.

Note: If you passed True to the SET AUTOMATIC RELATIONS command during the same session, calls to SET FIELD RELATION are ignored, regardless of whether they are placed before or after SET AUTOMATIC RELATIONS. To "lock" the automatic mode and take calls to SET FIELD RELATION into account, pass False to SET AUTOMATIC RELATIONS.

Example  

This command makes the management of relations easier in the Quick Report editor. In previous versions of 4D, it was necessary to set all relations as automatic to use them in the editor. Now, the following code allows setting only useful relations as automatic:

 SET AUTOMATIC RELATIONS(False;False`Reset of the relations
  `Only the following relations will be used
 SET FIELD RELATION([Invoices]Cust_IDt;Automatic;Automatic)
 SET FIELD RELATION([Invoice_Row]Invoice_ID;Automatic;Automatic)
 QR REPORT([Invoices];Char(1);True;True;True)

 
PROPERTIES 

Product: 4D
Theme: Relations
Number: 919

The OK variable is changed by the command

 
HISTORY 

Created: 4D 2004

 
SEE ALSO 

GET AUTOMATIC RELATIONS
GET FIELD RELATION
GET RELATION PROPERTIES
SET AUTOMATIC RELATIONS

 
TAGS 

Lien

 
ARTICLE USAGE

4D Language Reference ( 4D v12.4)
4D Language Reference ( 4D v11 SQL Release 6)
4D Language Reference ( 4D v14 R3)
4D Language Reference ( 4D v14 R2)
4D Language Reference ( 4D v13.5)
4D Language Reference ( 4D v14.3)
4D Language Reference ( 4D v14 R4)