Record.SetRecFilter() Method
Version: Available or changed with runtime version 1.0.
Sets the values in the current key of the current record as a record filter.
Syntax
Record.SetRecFilter()
Parameters
Record
Type: Record
An instance of the Record data type.
Remarks
The key isn't necessarily the primary key, the table view might be set to use a secondary key. All fields in the key as defined on the table are filtered. For more information the key selection, see SetCurrentKey Method.
Example
The following example uses the SetRecFilter method to set a filter on the Customer table, based a key set by the SetCurrentKey method. The GetFilters method) retrieves the filters and displays them in a message box. Because Name is the only field specified by the SetCurrentKey method, then the first key in the Customer table that starts with the field Name is used. In this case, for example, it's a secondary key defined as key(Key7; Name, Address, City)
.
var
CustomerRec: Record Customer;
varFilters: Text;
Text000: Label 'The filter is set on the fields: %1';
begin
CustomerRec.SetCurrentKey(Name);
CustomerRec.SetRecFilter();
varFilters := CustomerRec.GetFilters;
Message(Text000, varFilters);
end;
See Also
反馈
https://aka.ms/ContentUserFeedback。
即将发布:在整个 2024 年,我们将逐步淘汰作为内容反馈机制的“GitHub 问题”,并将其取代为新的反馈系统。 有关详细信息,请参阅:提交和查看相关反馈