"Field Check" CU 104015 compilation error

rdebath wrote:

Well of course I would suggest this ...

http://www.mibuso.com/dlinfo.asp?FileID=1149

Just run it with default options.

Thank you, I will try it.
Is this "Field Check" supposed to be as a replacement to Migrate.fob or just as a tool for additional checking before using standard methodology with Migrate.fob?

OK, thank you, Robert!

Luc Van Dyck wrote:

A few days ago I had the error "FIELDNO is not a function, etc." when I was using migrate.fob. This was caused by a table, which had a field called "FieldNo". Because FIELDNO is used as a function in this codeunit 104015, NAV does not know if you want to reference the field, or if you want to use the function with the same name.

My guess is that you have a field called "Fieldname" in table 17235. If you rename that field, the codeunit will compile.

Thank you, Luc!
Yes, there was a field called "Fieldname" in table 17235. I renamed it to "Fieldname1" and then tried to compile, but got another error:

When the function is called, the minimum number of parameters should be used. For example:

MyFunc( .. , .. , .. )
ROUND(MyVar)
ROUND(MyVar,0.05)

And the error occured on the same line of code (trigger Table17235), but after the first parameter "TableName" (I pointed it out by a line comment):

A17235.CHANGECOMPANY(F.GetCompanyName);
B17235.CHANGECOMPANY(F.GetCompanyName);
F.UpdateKey(A17235.CURRENTKEY);
A17235.MARKEDONLY := F.Modify;
IF A17235.FIND('-') THEN
  REPEAT
    B17235 := A17235;
    B17235.SETRECFILTER;
    F.Update(B17235.GETFILTERS);
    F.CheckText(B17235.FIELDNAME("TableName"),MAXSTRLEN(B17235."TableName"),B17235."TableName"); //the error is here, after the first "TableName"
    F.CheckText(B17235.FIELDNAME("FieldName"),MAXSTRLEN(B17235."FieldName"),B17235."FieldName");
    F.CheckText(B17235.FIELDNAME("Type Name"),MAXSTRLEN(B17235."Type Name"),B17235."Type Name");
    F.CheckText(B17235.FIELDNAME("Field Caption"),MAXSTRLEN(B17235."Field Caption"),B17235."Field Caption");
    F.CheckCode(B17235.FIELDNO("Division"),B17235.FIELDNAME("Division"),MAXSTRLEN(B17235."Division"),B17235."Division");
    F.CheckCode(B17235.FIELDNO("Header"),B17235.FIELDNAME("Header"),MAXSTRLEN(B17235."Header"),B17235."Header");
    F.CheckCode(B17235.FIELDNO("Component Line ID"),B17235.FIELDNAME("Component Line ID"),MAXSTRLEN(B17235."Component Line ID"),
B17235."Component Line ID");
    IF F.Modify THEN BEGIN
      A17235.DELETE;
      B17235.INSERT;
    END ELSE
      IF NOT A17235.MARK THEN
        A17235.MARK := F.Mark;
  UNTIL A17235.NEXT = 0;

Then I tried to rename yet another field in the table 17235 - TableName. I changed its name to TableName1. Then trying to compile I get an error on the same line (and exactly the same point) of code. The error message is following:

A field from a record variable was expected. For example:

Record.Field
Customer.Name

Luc Van Dyck wrote:

Did you generate the CU 104015 again, after you have modified the fieldnames in the table?

Thanks! That was the reason!
I changed back the TableName1 field to TableName, regenerated CU 104015, imported it again and, yes, it compiled without problems.

Should I return the initial name of a FieldName field in the table 17235 before running CU 104015 for scanning database?

Luc, thank you very much!