SET AUTOMATIC RELATIONS

4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next

version 2004 (Modified)


SET AUTOMATIC RELATIONS (one{; many})

ParameterTypeDescription
oneBooleanStatus of all Many-to-One relations
manyBooleanStatus of all One-to-Many relations

Description

SET AUTOMATIC RELATIONS temporarily changes all the manual relations into automatic relations for the entire database in the current process. The relations stay automatic unless a subsequent call to SET AUTOMATIC RELATIONS is made.

If one is true, then all manual Many-to-One relations will become automatic. If one is false, all previously changed Many-to-One relations will revert to manual relations.

The same is true for the many parameter, except that manual One-to-Many relations are affected.

Relations that are set as automatic in the Design environment are not affected by this command.

If all relations have been set as manual in the Design environment, this command makes it possible to change them to be automatic, just before executing operations that need the relation to be automatic (such as relational searches and sorts). After the operation is finished, the relation can be changed back to manual.

Example

The following example makes all manual Many-to-One relations automatic and reverts any previously changed One-to-Many relations:

   SET AUTOMATIC RELATIONS (True; False)

See Also

About Relations, GET AUTOMATIC RELATIONS, GET RELATION PROPERTIES, SELECTION RANGE TO ARRAY, SELECTION TO ARRAY, SET FIELD RELATION.


4D - Documentation   Français   English   German   Spanish   4D v11 SQL, Command Theme List   4D v11 SQL, Command Alphabetical List   4D v11 SQL, Constant Theme List   Back   Previous   Next