mibuso.com
Home› NAV/Navision Classic Client

Nav table not visible in sql

wilk_uwilk_u Member Posts: 94
edited 2013-11-07 in NAV/Navision Classic Client
Hello,
I have a strange problem: I've created a custom table in nav, works fine but it's not visible in sql management studio. How is this possible?
Thanks for any suggestions!

Comments

  • geordiegeordie Member Posts: 655
    Which ID range did you use? Are you able to insert any record (from NAV)?
    Did you change LinkedObject property?
    * Daniele Rebussi * | * Rebu NAV Diary *
  • wilk_uwilk_u Member Posts: 94
    Table Id is 50013, it works well in nav, inserting etc. linked object property is set to no.
    table 50015 has the same properties and it is visible in sql..
    Is there any property/setup which can affect this?
  • davmac1davmac1 Member Posts: 1,283
    Is datapercompany set to yes or no?
    The table name will have the companyname$ prefixed to it if yes and not prefixed if it is no.
    David Machanick
    http://mibuso.com/blogs/davidmachanick/
  • wilk_uwilk_u Member Posts: 94
    Thank you davmac1, dataperCompany was the key:) It was pretty hard to find table without company prefix when there is nearly 20 companies in the db.
    Thanks guys, you're the best support, as always!
  • davmac1davmac1 Member Posts: 1,283
    Glad I could help. :D
    David Machanick
    http://mibuso.com/blogs/davidmachanick/
Sign In or Register to comment.