Behavior of code datatype in navision

himabindumlh
himabindumlh Member Posts: 24
edited 2008-01-11 in Navision Attain
hi

Can anyone pls tell me how do code datatype behaves while used in setrange function.

Is there any diff in its behavior with native database and sql database in navision.

Comments

  • NaviDeveloper_NL
    NaviDeveloper_NL Member Posts: 42
    The filtered recordset is be the same in native / SQL server. Sorting could be different.
  • Belias
    Belias Member Posts: 2,998
    If you populate sql tables also with applications different from nav.
    or you use some store procedures to populate code fields, remember that nav does not recognise codes in lowercase
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • kriki
    kriki Member, Moderator Posts: 9,121
    Belias wrote:
    If you populate sql tables also with applications different from nav.
    or you use some store procedures to populate code fields, remember that nav does not recognise codes in lowercase
    Even worse: NAV freaks out on this and then you have to fix it on SQL.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

  • Belias
    Belias Member Posts: 2,998
    Can't I fix it like this http://www.mibuso.com/forum/viewtopic.php?t=21295 too?
    -Mirko-
    "Never memorize what you can easily find in a book".....Or Mibuso
    My Blog
  • kriki
    kriki Member, Moderator Posts: 9,121
    Belias wrote:
    Can't I fix it like this http://www.mibuso.com/forum/viewtopic.php?t=21295 too?
    If it doesn't generate an error, probably yes.
    Regards,Alain Krikilion
    No PM,please use the forum. || May the <SOLVED>-attribute be in your title!

Categories