Before subselection

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 11 (Modified)


Before subselection (subtable) Boolean

ParameterTypeDescription
subtableSubtableSubtable for which to test if subrecord pointer is
before the first selected subrecord
Function resultBooleanYes (TRUE) or No (FALSE)

Compatibility note: Subtables are no longer supported starting with version 11 of 4D. A compatibility mechanism ensures the functioning of this command in converted databases; however, it is strongly recommended to replace any subtables with standard related tables.

Description

Before subselection returns True when the current subrecord pointer is before the first subrecord of subtable. Before subselection is used to check whether or not PREVIOUS SUBRECORD has moved the pointer before the first subrecord. If the current subselection is empty, Before subselection returns True.

Example

The following example is an object method for a button. When the button is clicked, the pointer moves to the previous subrecord. If the pointer is before the first subrecord, it moves to the last subrecord:

   PREVIOUS SUBRECORD ([People]Children)   ` Move to the previous subrecord
   If (Before subselection ([People]Children)   ` If we have gone too far...
      LAST SUBRECORD ([People]Children)   ` move to the last subrecord 
   End if

See Also

PREVIOUS SUBRECORD.


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