CodeCop Warning AA0181
The FindSet() or Find() methods must be used only in connection with the Next() method.
Description
Avoid getting the dataset when an enumeration is not used, which will decrease performance.
Reason for the rule
If you use FindSet()
or Find()
you must have a Next()
method. Otherwise, you are wasting CPU and bandwidth since multiple records are loaded but you only use one.
Bad code example
codeunit 1 MyCodeunit
{
var
customer: Record Customer;
procedure Foo()
begin
if customer.FindFirst() then
repeat
...
until customer.Next() = 0;
end;
}
Good code example
codeunit 1 MyCodeunit
{
var
customer : Record Customer;
procedure Foo()
begin
if customer.FindSet() then
repeat
...
until customer.Next() = 0;
end;
}
See Also
Feedback
https://aka.ms/ContentUserFeedback.
Coming soon: Throughout 2024 we will be phasing out GitHub Issues as the feedback mechanism for content and replacing it with a new feedback system. For more information see:Submit and view feedback for