Notifications
Announcements
No record found.
Hi everyone , i change the type of the county field frim text to option but when i tried to add a new customer this error appeared
*This post is locked for comments
Hi Kamilia,
Please close the application and open it again freshly. The datatype change has not reflected yet.
If the problem still persists, restart your NAV instance.
Hope it helps.
it doesn't work
Hi,
It seems like you have not recompiled the objects.
Please recompile the object(s) that you have made the change(s).
i am getting this error
You are trying to concatenate text and an option.
If you want to add Text and Option and return a Text value, use FORMAT() for your option like following,
TextResult := Text + FORMAT(Option);
Hey Kamilia,
Restart your NAV service from Services.MSC. It will then work for sure.
where can i add this ?
When the error pops up, close the error window and the system will take you to the line where the error occurred. So do the change as I mentioned on my previous answer. Recompile the object again.
The First Question is - Why you want to change a standard field data type?
If you still plan to change it you need to identify where all that field is used. Third party tools like Prism should be used to find the relation of tables / fields in whole system.
The issue that you are facing is due to standard function ValidateCity call that is being called and need a parameter Country Code.
I think you need to analyze that a New Custom Field for Country Options seems a good idea.
Under review
Thank you for your reply! To ensure a great experience for everyone, your content is awaiting approval by our Community Managers. Please check back later.
As AI tools become more common, we’re introducing a Responsible AI Use…
We are honored to recognize Neeraj Kumar as our Community Spotlight honoree for…
These are the community rock stars!
Stay up to date on forum activity by subscribing.
