The type NavBoolean is unknown

alex9alex9 Posts: 123Member
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.
NavBoolean2.bmp
491K

Answers

  • SavatageSavatage Posts: 7,132Member
    Try using the debugger. It will help you pinpoint the problem.
  • alex9alex9 Posts: 123Member
    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 Posts: 7,132Member
    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 Posts: 123Member
    Yes, I know what debugger is, and I tried to use it in this case. Nothing happened.
  • dipakpatel2505dipakpatel2505 Posts: 169Member
    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 Posts: 123Member
    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 Posts: 3Member
    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 Posts: 3Member
    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 Posts: 638Member
    You may query the table Field filtering by RelationTableNo = [YourTable] and RelationFieldNo = [YourField].
  • madalynmadalyn Posts: 3Member
    I finally found it by exporting all the recently modified tables as txt and searched for the table name
Sign In or Register to comment.