The type NavBoolean is unknown

alex9alex9 Member Posts: 97
edited 2015-03-26 in NAV Three Tier
I am getting the following error when trying to rename the record in the table. Any ideas? There is no any code OnRename trigger. NAV2013.

Answers

  • SavatageSavatage Member Posts: 7,142
    Try using the debugger. It will help you pinpoint the problem.
  • alex9alex9 Member Posts: 97
    Savatage wrote:
    Try using the debugger. It will help you pinpoint the problem.
    Debugger doesn't help. There is no any code neither at OnRename trigger nor Code - OnValidate. Also, there is no TableRelation on this field. PrimaryKey contains of one field (Code) only.
  • SavatageSavatage Member Posts: 7,142
    So are you saying..you tried the debugger and nothing happened or you didn't try at all?

    http://msdn.microsoft.com/en-us/library/dd354968.aspx
  • alex9alex9 Member Posts: 97
    Yes, I know what debugger is, and I tried to use it in this case. Nothing happened.
  • dipakpatel2505dipakpatel2505 Member Posts: 169
    Hi Alex9,

    The code field is primary key field and in other table, Fields are connected with this field using Table Relation.

    The problem might be that when you try to rename field "Code" shown in screenshot, it also goes to update other field value whose are connected with "Code" field in Table relation Property. You should check for all fields and their data type which are connected with "Code" field and their data type.

    I think data type of any one field does not match with the data type of "Code" field .

    If suggestion has solved your problem then please do not forget to mark it as solved.
  • alex9alex9 Member Posts: 97
    Hi Alex9,

    The code field is primary key field and in other table, Fields are connected with this field using Table Relation.

    The problem might be that when you try to rename field "Code" shown in screenshot, it also goes to update other field value whose are connected with "Code" field in Table relation Property. You should check for all fields and their data type which are connected with "Code" field and their data type.

    I think data type of any one field does not match with the data type of "Code" field .

    If suggestion has solved your problem then please do not forget to mark it as solved.
    Hi dipakpatel2505,
    You are absolutely right! I searched for table relations throughout the whole database and found boolean field in another table with relation to this Code field. Thanks a lot for your help! :)
  • madalynmadalyn Member Posts: 3
    I am getting this same error on trying to rename a record in a new custom table with the primary key a Code 10 field. There are 4 tables with fields relating to this table but all are defined correctly as Code 10. How did you find a field of type Boolean with a table relation to this table? Or what else could be causing this error?
  • madalynmadalyn Member Posts: 3
    I am getting this same error on trying to rename a record in a new custom table with the primary key a Code 10 field. There are 4 tables with fields relating to this table but all are defined correctly as Code 10. How did you find a field of type Boolean with a table relation to this table? Or what else could be causing this error?
  • geordiegeordie Member Posts: 655
    You may query the table Field filtering by RelationTableNo = [YourTable] and RelationFieldNo = [YourField].
  • madalynmadalyn Member Posts: 3
    I finally found it by exporting all the recently modified tables as txt and searched for the table name
  • HyB_Br33DHyB_Br33D Member Posts: 1
    I had the same issue this week while renaming customer record.

    Then i found this discussion of which @dipakpatel2505's insight came in handy and @madalyn's idea of exporting objects to txt was very efficient.

    So I filtered my objects to those modified, exported it to text and searched for customer table, then i saw the boolean field relating to customer table o:)

    e6o1an9fne4w.jpg
Sign In or Register to comment.