ONE RECORD SELECT

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 3


ONE RECORD SELECT {(aTable)}

ParameterTypeDescription
aTableTableTable in which to reduce the
selection to the current record, or
Default table, if omitted

Description

ONE RECORD SELECT reduces the current selection of aTable to the current record. If no current record exists or if the current record is not loaded into memory (special case), ONE RECORD SELECT has no effect.

Historical Note: This command was useful to "return" a record that had been pushed and popped from the record stack back to the selection while the selection for the table was changed. In version 6, SET QUERY DESTINATION allows you to make a query without changing the selection or the current record of a table; therefore, you no longer need to push and pop a current record in order to query its table. Consequently, ONE RECORD SELECT is less useful, unless you actually want to reduce the selection of a table to the current record.


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