SETPOSITION Function (RecordRef)
Sets the fields in a primary key on a record to the values specified in the String parameter. The remaining fields are not changed.
The RecordRef that refers to the record.
Type: Text or Code
The string that is used to set the primary key. This string contains the primary key value to set.
This function works the same as the SETPOSITION Function (Record).
The following example changes the value in the primary key, the No. field, in table 23 (Vendor). Other fields are not changed. The code starts by opening table 23 (Vendor) as a RecordRef variable that is named MyRecordRef. The FIELD Function (RecordRef) selects the first field (No.) and stores the value in the MyFieldRef variable. The SETFILTER Function (FieldRef) sets a filter that selects records from 10000 to 20000. The FINDLAST Function (RecordRef) finds and retrieves the last record in the record set. The SETPOSITION function changes the value in the No. field from 20000 to 20001. The record No. and the name of the record are displayed before and displayed again after the primary key value is changed. The string that contains the new primary key is initialized in the InputString variable. This example requires that you create the following variables and text constants in the C/AL Globals window.
|Text constant name||DataType||ENU value|
|Text000||Text||The record No. before the primary key was changed is %1.\ The vendor name before the primary key was changed is %2.|
|Text001||Text||The record No. after the primary key was changed is %1. \ The vendor name after the primary key was changed is %2.|
InputString := 'No.=CONST(20001)'; MyRecordRef.OPEN(23); MyFieldRef := MyRecordRef.FIELD(1); MyFieldRef.SETFILTER('10000..20000'); MyRecordRef.FINDLAST; MESSAGE(Text000, MyRecordRef.RECORDID, MyRecordRef.FIELD(2)); MyRecordRef.SETPOSITION(InputString); MESSAGE(Text001, MyRecordRef.RECORDID, MyRecordRef.FIELD(2));
The following is displayed before the SETPOSITION function is called:
The record No. before the primary key was changed is Vendor: 20000.
The vendor name before the primary key was changed is AR Day property Management.
The following is displayed after the SETPOSITION function is called:
The record No. after the primary key was changed is Vendor: 20001.
The vendor name after the primary key was changed is AR Day property Management.