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;