Check parameters of a .Get() function call.

[christianbraeunlich]

Hello there,
I'm not sure if it's possible to check the parameters of a .Get() function call via static code analyzers.

The goal of this rule is to deal with

• insufficient number of parameters provided in a .Get() function
• number of parameter exeeds the number of primary key fields of the specific record (btw: max. number of primary key fields = 16 due to sql server limiations - could be a separate rule)
• compare parameters datatype
• compare record field tablerelation

Like in the following examples:

Example 1: different datatype

codeunit 50100 Check
{
    local procedure Test()
    var
        itemVendor: Record "Item Vendor";
        itemNo: Code[20];
        vendorNo, variantCode: Code[10];
    begin
        ItemVendor.Get(vendorNo, itemNo, variantCode);  // Rule-LC000XX: The datatype of the 1st parameter "vendorNo" is Code[10] and must match the datatype of the 1st primary key field "Vendor No.": Code[20]
    end;
}

Example 2: compare fields tablerelations

codeunit 50100 CheckTableRelation
{
    local procedure Test()
    var
        myCustomTable: Record MyCustomTable;
        itemVendor: Record "Item Vendor";
        itemNo: Code[20];
        variantCode: Code[10];
    begin
        if myCustomTable.FindFirst() then
            itemVendor.Get(myCustomTable."Customer No.", itemNo, variantCode);  // Rule-LC000XX: The 1st parameter 'myCustomTable."Customer No."' has a TableRelation that does not match the TableRelation of Record "Item Vendor" 1st primary key field (Vendor."No.")
    end;
}

table 50100 MyCustomTable
{
    ...
    field(50100; "Customer No."; Code[20])
    {
        TableRelation = Vendor."No.";
    }
    ...
}

Example 3: compare number of parameters with the number of primary key fields

codeunit 50100 CheckNumberParameter
{
    local procedure Test()
    var
        itemVendor: Record "Item Vendor";
        vendorNo, itemNo: Code[20];
        variantCode: Code[10];
        lineNo: Integer;
    begin
        itemVendor.Get(vendorNo, itemNo, variantCode, lineNo);  // Rule-LC000XX: The number of parameters exeeds the number of primary key fields of the "Item Vendor" record.
        // OR
        itemVendor.Get(vendorNo, itemNo);  // Rule-LC000XX: The number of parameters is not sufficient for the number of primary key fields of the "Item Vendor" record. Add 1 additional required parameter.
    end;
}

Any additional thoughts on this? Is there already a rule I haven't found yet?