Exam MB-820 Topic 2 Question 108 Discussion
Actual exam question for Microsoft's MB-820 exam
Question #: 108
Topic #: 2
Question #: 108
Topic #: 2
You are writing a procedure to block all inventory items with numbers that do not start with the letter S.
You need to complete the procedure.
How should you complete the code expressions? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

You need to complete the procedure.
How should you complete the code expressions? To answer, select the appropriate options in the answer area.
NOTE: Each correct selection is worth one point.

Suggested Answer:

Explanation:

procedure BlockNonSItems()
var
Item: Record Item;
begin
// Reset the Item record to clear any previous filters.
Item.Reset();
// Set the filter to exclude items that start with 'S'.
Item.SetFilter("No.", '<>%1*', 'S');
// Find each item that matches the filter.
if Item.FindSet() then
repeat
// Set the Blocked field to true to block the item.
Item.Blocked := true;
// Save the changes to the Item record.
Item.Modify();
until Item.Next() = 0; // Continue until no more items are found.
end;
by Matt at Jul 12, 2026, 11:20 PM
0
0
0
10
Comments
Upvoting a comment with a selected answer will also increase the vote count towards that answer by one. So if you see a comment that you already agree with, you can upvote it instead of posting a new comment.
Report Comment
Commenting
You can sign-up / login (it's free).