mibuso.com

Microsoft Business Solutions online community
It is currently Sun May 31, 2015 12:16 am

All times are UTC + 1 hour [ DST ]




Post new topic Reply to topic  [ 11 posts ] 
Author Message
 Post subject: [Solved] The type NavBoolean is unknown
PostPosted: Fri Apr 19, 2013 9:59 pm 
Offline

Joined: Thu Dec 01, 2005 5:51 pm
Posts: 83
Location: Toronto
Country: Canada (ca)
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.


Attachments:
NavBoolean2.bmp
NavBoolean2.bmp [ 491.01 KiB | Viewed 1412 times ]


Last edited by alex9 on Mon Apr 22, 2013 4:40 pm, edited 1 time in total.
Top
 Profile  
 
 Post subject: Re: The type NavBoolean is unknown
PostPosted: Sat Apr 20, 2013 2:07 am 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Jun 06, 2003 9:01 pm
Posts: 7093
Location: L.I., New York
Country: United States (us)
Try using the debugger. It will help you pinpoint the problem.

_________________
Harry Ruiz
http://www.BiloBeauty.com
http://www.autismspeaks.org


Top
 Profile E-mail WWW  
 
 Post subject: Re: The type NavBoolean is unknown
PostPosted: Sat Apr 20, 2013 6:57 pm 
Offline

Joined: Thu Dec 01, 2005 5:51 pm
Posts: 83
Location: Toronto
Country: Canada (ca)
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.


Top
 Profile  
 
 Post subject: Re: The type NavBoolean is unknown
PostPosted: Sun Apr 21, 2013 3:48 pm 
Offline
MVP Microsoft Dynamics NAV

Joined: Fri Jun 06, 2003 9:01 pm
Posts: 7093
Location: L.I., New York
Country: United States (us)
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

_________________
Harry Ruiz
http://www.BiloBeauty.com
http://www.autismspeaks.org


Top
 Profile E-mail WWW  
 
 Post subject: Re: The type NavBoolean is unknown
PostPosted: Mon Apr 22, 2013 12:36 am 
Offline

Joined: Thu Dec 01, 2005 5:51 pm
Posts: 83
Location: Toronto
Country: Canada (ca)
Yes, I know what debugger is, and I tried to use it in this case. Nothing happened.


Top
 Profile  
 
 Post subject: Re: The type NavBoolean is unknown
PostPosted: Mon Apr 22, 2013 7:51 am 
Offline

Joined: Tue Sep 23, 2008 1:30 pm
Posts: 121
Country: India (in)
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.


Top
 Profile E-mail  
 
 Post subject: SOLVED: The type NavBoolean is unknown
PostPosted: Mon Apr 22, 2013 4:39 pm 
Offline

Joined: Thu Dec 01, 2005 5:51 pm
Posts: 83
Location: Toronto
Country: Canada (ca)
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! :)


Top
 Profile  
 
 Post subject: Re: The type NavBoolean is unknown
PostPosted: Thu Mar 26, 2015 7:23 pm 
Offline

Joined: Wed Mar 24, 2010 4:48 pm
Posts: 3
Country: United States (us)
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?


Top
 Profile E-mail  
 
 Post subject: Re: The type NavBoolean is unknown
PostPosted: Thu Mar 26, 2015 7:23 pm 
Offline

Joined: Wed Mar 24, 2010 4:48 pm
Posts: 3
Country: United States (us)
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?


Top
 Profile E-mail  
 
 Post subject: Re: The type NavBoolean is unknown
PostPosted: Thu Mar 26, 2015 7:41 pm 
Offline

Joined: Thu Oct 21, 2010 4:59 pm
Posts: 600
Location: Munich
Country: Germany (de)
You may query the table Field filtering by RelationTableNo = [YourTable] and RelationFieldNo = [YourField].

_________________
* Daniele Rebussi * | * Rebu NAV Diary *


Top
 Profile E-mail WWW  
 
 Post subject: Re: The type NavBoolean is unknown
PostPosted: Thu Mar 26, 2015 7:44 pm 
Offline

Joined: Wed Mar 24, 2010 4:48 pm
Posts: 3
Country: United States (us)
I finally found it by exporting all the recently modified tables as txt and searched for the table name


Top
 Profile E-mail  
 
Display posts from previous:  Sort by  
Post new topic Reply to topic  [ 11 posts ] 

All times are UTC + 1 hour [ DST ]


Who is online

Users browsing this forum: No registered users and 3 guests


You cannot post new topics in this forum
You cannot reply to topics in this forum
You cannot edit your posts in this forum
You cannot delete your posts in this forum
You cannot post attachments in this forum


Search for:
Jump to: