Issue with CODE data type

Chowdary
Chowdary Member Posts: 148
edited 2013-02-22 in NAV Three Tier
Hello!

I got to check filed of type CODE values contains A..Z,1..9 and all possible combinations. I have no problem if both fields are numbers. But if field1 = 3 and field2 = A then navision saying A is gretaer than 3. But im my data it should be A is less than 3. How to solve the issue?

any ideas or previous post links of same issues are highly appreciated

Thank You
Chowdary
Pleasure in the job puts perfection in the work

Comments

  • rafal
    rafal Member Posts: 23
    Sort order depends on used database (native/sql) and codepage, you don't have possibility to change this sort order. In this case, you can't sort this data like you want.

    You can try to create additional key with order like you need.

    There are a lot of problems with proper sorting of code fileds, and you will find on mibuso.com many information about it.
    Rafał
    http://www.nav.info.pl (The first polish blog about Microsoft Dynamics NAV)
  • pdj
    pdj Member Posts: 643
    You should even be aware, that the sort order of a temporary table isn't always the same as the actual table:
    http://ppe.blogs.msdn.com/b/nav/archive ... nment.aspx
    I think this was changed for NAV2013, but I haven't tested it.
    Regards
    Peter

Categories