The type NavBoolean is unknown

alex9 · 2013-04-19

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.

Savatage · 2013-04-20

Try using the debugger. It will help you pinpoint the problem.

alex9 · 2013-04-20

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.

Savatage · 2013-04-21

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

alex9 · 2013-04-21

Yes, I know what debugger is, and I tried to use it in this case. Nothing happened.

dipakpatel2505 · 2013-04-22

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.

alex9 · 2013-04-22

dipakpatel2505 wrote:

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!

madalyn · 2015-03-26

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?

madalyn · 2015-03-26

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?

geordie · 2015-03-26

You may query the table Field filtering by RelationTableNo = [YourTable] and RelationFieldNo = [YourField].

madalyn · 2015-03-26

I finally found it by exporting all the recently modified tables as txt and searched for the table name

HyB_Br33D · 2022-06-18

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

The type NavBoolean is unknown

Answers

Categories