{"id":973,"date":"2016-07-15T18:55:13","date_gmt":"2016-07-15T16:55:13","guid":{"rendered":"http:\/\/blog.systemconnect.dk\/?p=973"},"modified":"2016-06-16T09:05:45","modified_gmt":"2016-06-16T07:05:45","slug":"nav-sql-teknik","status":"publish","type":"post","link":"https:\/\/scblog.lynge.org\/?p=973","title":{"rendered":"NAV SQL teknik"},"content":{"rendered":"<p>Du kan <a href=\"http:\/\/blog.systemconnect.dk\/?p=219\">ved at klikke her!<\/a> l\u00e6se vores\u00a0indl\u00e6g om hvordan Klassisk Dynamics C5 lagrer sine data p\u00e5 SQL og hvad man eller skal passe p\u00e5.<\/p>\n<p>Men hvad med Dynamics NAV og Dynamics C5?<br \/>\n(Herefter blot omtalt som NAV da C5 jo bygger p\u00e5 samme teknologi).<\/p>\n<p>Dynamics NAV er ikke s\u00e5 &#8220;vanskelig&#8221; som Klassisk Dynamics C5 omkring SQL, men nogle ting skal man lige vide:<\/p>\n<ul>\n<li>Man b\u00f8r aldrig l\u00e6se eller skrive data direkte til NAVs SQL-database. Det er et usupporteret scenarie, s\u00e5 at du l\u00e6ser dette viser at du er p\u00e5 vildspor :-).<br \/>\nBenyt i stedet ODATA eller SOAP webservices.<\/li>\n<li>Options lagres p\u00e5 SQL som deres tilsvarende nummer (der ogs\u00e5 kan benyttes i NAV). Nummereringen starter med 0 for f\u00f8rste v\u00e6rdi osv. Husk at i NAV er en tom v\u00e6rdi en placeholder (dvs. den f\u00e5r et nummer, men vises ikke i evt. drop-downs for feltet. Skal den vises skal den indeholde et mellemrum).<\/li>\n<li>Datoer lagres som DATETIME (ligesom i Klassisk Dynamics C5) og hvor alm. datoer har tidspunket 00:00:00.\u00a0Der er ingen primodatoer i NAV, men hvis Ultimoflaget er sat er tidspunktet 23:59:59.<\/li>\n<\/ul>\n<p>&#8230;og husk nu at du slet ikke m\u00e5 tilg\u00e5 SQL databasen direkte &#8211; det er hverken supporteret p\u00e5 Klassisk Dynamics C5 eller p\u00e5 Dynamics NAV\/C5.<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Du kan ved at klikke her! l\u00e6se vores\u00a0indl\u00e6g om hvordan Klassisk Dynamics C5 lagrer sine data p\u00e5 SQL og hvad man eller skal passe p\u00e5. Men hvad med Dynamics NAV og Dynamics C5? (Herefter blot omtalt som NAV da C5 &hellip; <a href=\"https:\/\/scblog.lynge.org\/?p=973\">L\u00e6s resten <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[40,41,38,32,35,36],"tags":[15,43,22,11,54,52,23,53,14,42,44,31,57,56,28,20,55],"class_list":["post-973","post","type-post","status-publish","format-standard","hentry","category-c5-support","category-c5-teknik","category-dynamics-c5","category-dynamics-nav","category-nav-support","category-nav-teknik","tag-business-solutions","tag-c5","tag-database","tag-dynamics","tag-dynamics-c5","tag-dynamics-nav","tag-hint","tag-klassisk-c5","tag-microsoft","tag-nav","tag-navigator","tag-navision","tag-odata","tag-soap","tag-sql","tag-udokumenteret","tag-webservice"],"_links":{"self":[{"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts\/973","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcomments&post=973"}],"version-history":[{"count":1,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts\/973\/revisions"}],"predecessor-version":[{"id":974,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts\/973\/revisions\/974"}],"wp:attachment":[{"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=973"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=973"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=973"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}