Today I’ve spent some time in NAV2016 figuring out this error message:
As you know in NAV2016 you can sort on each column even if there is no key and even if it’s a flowfield. So why am I getting this error?
In my case the Test field is a Flowfield of the type COUNT to another table. This should work fine, so why doesn’t it work here.
Reason is that the SQL Data Type is Integer instead of VarChar. A very old trick to make a SQL Database sort a Code field just like the Native database.
The SQL Data Type in the “Other” table does not match this SQL Type hence the sorting fails.
Since I could not find any info online on this message I thought it was worth sharng.
Totovic NAV Blog
In this moment, we have the final countdown until Dynamics NAV conference season will start. We have 47 days until the opening Directions NA and 64 days until the opening Directions EMEA this year.
This year Direction NA will be held the first, but Directions EMEA will be only 17 days later and I’m sure we have something new on both of them. Currently we have published agenda only for Directions NA, but I’m pretty sure that agendas will be similar, maybe with only small changes.
I love these conferences and I’m sure you will find a lot of reasons to attend on one of them, depending where you actually live. I think that the most important reasons will be launching of NAV 2017 and Project “Madeira” as well as Dynamics 365. You will find a lot of sessions about news in these new products. You will also learn more about…
View original post 174 more words