{"id":247,"date":"2012-12-10T20:54:20","date_gmt":"2012-12-10T19:54:20","guid":{"rendered":"http:\/\/blog.systemconnect.dk\/?p=247"},"modified":"2016-08-17T18:53:35","modified_gmt":"2016-08-17T16:53:35","slug":"det-gra-c5-guld-2gb-database-ought-to-be-enough-for-anybody","status":"publish","type":"post","link":"https:\/\/scblog.lynge.org\/?p=247","title":{"rendered":"Det Gr\u00e5 C5 Guld"},"content":{"rendered":"<p>Ber\u00f8mte (og\u00a0mere eller mindre korrekte, men sjove historiske citater) inkluderer:<\/p>\n<ul>\n<li>&#8220;Everything that can be invented has been invented&#8221;<br \/>\nCharles Holland Duell I, Kommis\u00e6r for United States Patent and Trademark Office (1902)<\/li>\n<li>&#8220;Two Years from Now, Spam will be solved&#8221;<br \/>\nBill Gates, bestyrelsesformand for Microsoft (2004) i World Economics Forum<\/li>\n<li>&#8220;Who the hell wants to hear actors talk?&#8221;<br \/>\nH.M. Warner, Warner Brothers (1927)<\/li>\n<li>&#8220;We don&#8217;t like their sound, and guitar music is on the way out&#8221;,<br \/>\nDecca Recording Co. der afviser The Beatles (1962)<\/li>\n<li>&#8220;The wireless music box (red. radioen) has no imaginable commercial value. Who vould pay for a message sent to nobody in particular?&#8221;,<br \/>\nDavid Sarnoff&#8217;s r\u00e5dgivere da han ville investere i radioteknologi (1920&#8217;erne)<\/li>\n<li>&#8220;Heavier-than-air flying machines are impossible&#8221;,<br \/>\nLord Kelvin, Presiden for Royal Society (1895)<\/li>\n<li>&#8220;I think there&#8217;s a world market for maybe 5 computers&#8221;,<br \/>\nThomas Watson, Bestyrelsesformand for IBM (1943)<\/li>\n<li>&#8220;Computers in the future will weigh no more than 1.5 tons&#8221;,<br \/>\nPopul\u00e6r Mekanik USA (1949)<\/li>\n<li>&#8220;Clever, but, what is a microchip good fore?&#8221;,<br \/>\nIBM-ingeni\u00f8r (1952)<\/li>\n<li>&#8220;There is no reason why anyone would want to have a computer in their home&#8221;,<br \/>\nKen Olson, bestyrelsesformand for Digital Equipment Corporation (1977)<\/li>\n<li>&#8220;This &#8216;Telephone&#8217; has too many shortcomings to be seriously considered as a means of communication. The device is inherently of no value to us&#8221;,<br \/>\nWestern Union\u00a0internt memo (1876)<\/li>\n<li>&#8230;og m\u00e5ske det mest ber\u00f8mte: &#8220;640K (RAM) ought to be enough for anybody&#8221;,<br \/>\nBill Gates, bestyrelsesformand for Microsoft (1981)<\/li>\n<\/ul>\n<p>Sidstn\u00e6vnte var grunden til 640KB RAMs begr\u00e6nsningen i det gamle styresystem DOS.<\/p>\n<p>Men vidste du at et par Damgaard br\u00f8dre med lidt god vilje n\u00e6sten kan citeres for at have sagt &#8220;Et 2GB C5\u00a0regnskab m\u00e5 alts\u00e5 v\u00e6re nok\u00a0til alle virksomheder&#8221;?<\/p>\n<p>I C5 f\u00f8r version 4.0 er sagen den, at selvom FAT-filsystemet\u00a0allerede degang\u00a0tillod filer p\u00e5 4GB, s\u00e5 kunne C5 faktisk ikke h\u00e5ndtere mere end 2GB databaser&#8230; Det skyldes dog heldigvis kun nogle sm\u00e5fejl i applikationskoden, s\u00e5 med nogle f\u00e5 kunstgreb kan gr\u00e6sen flyttes til 4GB.<\/p>\n<p>Skal du absolut\u00a0fylde mere end 4GB, s\u00e5 m\u00e5 du ty til C5s SQL-udgaver (som dog f\u00f8rst findes fra version 3.0 og frem) eller split-file, der er beskrevet her: <a title=\"Selv en Native kan v\u00e6re en Goliat\" href=\"http:\/\/blog.systemconnect.dk\/?p=34\">Selv en Native kan v\u00e6re en Goliat<\/a>\u00a0(Bem\u00e6rk: vi har\u00a0ikke testet om split-files faktisk g\u00f8r at der kan h\u00e5ndteres data p\u00e5 mere end 4GB &#8211; men SQL kan med sikkerhed :-)).<\/p>\n<p>&#8220;Jamen hvorfor gider i overhovedet skrive om s\u00e5dan nogle gamle C5-versioner p\u00e5 jeres blog?&#8221;. Faktisk k\u00f8rer der stadig relativt mange gamle C5&#8217;ere med denne fejl. Og folk stopper trods alt data i dem hver dag&#8230; S\u00e5 der er potentielt mange der vil falde i denne &#8220;bug&#8221; f\u00f8r eller siden &#8211; og den er faktisk ikke ret godt beskrevet p\u00e5 nettet&#8230; Derfor dette blogindl\u00e6g om\u00a0de aldrende C5-udgaver. For selv om man forl\u00e6ngst har n\u00e5et pensionsalderen, kan ogs\u00e5 Det Gr\u00e5 C5 Guld v\u00e6re gavnligt i det danske erhvervsliv (selv om vi til enhver tid naturligvis vil anbefale en opgradering \ud83d\ude42 ).<\/p>\n<p>Hvis du vil klarg\u00f8re din C5 fra f\u00f8r version 4.0\u00a0til mere end 2GB, skal du rette f\u00f8lgende steder i applikationen (bem\u00e6rk: rettelserne kr\u00e6ver basis udvikling og ledige formtilpasninger og de er baseret p\u00e5 rettelserne mellem C5 version 3.0sp3 og 4.0):<\/p>\n<ul>\n<li>TmpKontoSum.DBD: Afdeling udvides til 20 tegn<\/li>\n<li>TmpDatoSum.DBD: Afdeling\u00a0udvides til 20 tegn<\/li>\n<li>TmpBetaling.DBD: Id\u00a0udvides til 20 tegn<\/li>\n<li>TmpPayCalculate.DBD: Department udvides til 20 tegn<\/li>\n<li>TmpPaySum.DBD: Txt1, Txt2, Txt3, Txt4 og Txt5 udvides til 20 tegn<\/li>\n<li>Forms.MAC:\u00a0Tre forekomster af &#8220;Int2Str(%1.RecID)&#8221; rettes\u00a0til &#8220;Num2Str(%1.RecID,0,0,0,0)&#8221; i #LocalMacro.NotatBox, #LocalMacro.NotatPreKey og #LocalMacro.InfoPreKey<\/li>\n<li>OrdreIndk\u00f8b_Opsaml.MAC:\u00a0En forekomster af &#8220;Int2Str(%1.RecID)&#8221; rettes\u00a0til &#8220;Num2Str(%1.RecID,0,0,0,0)&#8221; i #LocalMacro.OpsamlLinie<\/li>\n<li>Inbox.FRM: I USRKEY1 rettes &#8220;UInt2Str(Inbox.RecID)&#8221; til &#8220;Num2Str(Inbox.RecID,0,0,0,0)&#8221;<\/li>\n<li>eSalesWorksheet.FRM: I Pre-Key og Pre-Menu rettes &#8220;UInt2Str(eSalesTable.RecID)&#8221; til &#8220;Num2Str(eSalesTable.RecID,0,0,0,0)&#8221;<\/li>\n<li>Notat.FRM: I Init rettes &#8220;STR 12\u00a0 &amp;TmpTxt&#8221; til &#8220;STR 20\u00a0 &amp;TmpTxt&#8221;<\/li>\n<li>DebRente: I Pre-Body rettes &#8220;UInt2Str(DebPost.RecId)&#8221; til &#8220;Num2Str(DebPost.RecId,0,0,0,0)&#8221;<\/li>\n<\/ul>\n<p>Husk at multi-overs\u00e6tte alt efter rettelserne.<\/p>\n<p>Bem\u00e6rk: Ovenst\u00e5ende rettelser sker p\u00e5 egen regning og risiko. Vi p\u00e5tager os intet ansvar for korrekt funktion af C5 efter ovenst\u00e5ende rettelser, men hj\u00e6lper dig gerne med at lave rettelserne &#8211; eller (det vi anbefaler) opgradere din C5 til nyeste udgave i stedet. Du skal ogs\u00e5 v\u00e6re opm\u00e6rksom p\u00e5 at der kan v\u00e6re egne tilpasninger eller 3. parts moduler, der kan\u00a0indeholder fejl omkring databasest\u00f8rrelser over 2GB.<\/p>\n<p>Bem\u00e6rk ogs\u00e5 at Klassisk Dynamic C5s ODBC Connector til Native pga. en bug ikke supporterer 2GB f\u00f8r version 2012 Service Pack 2 Hotfix 12.\u00a0<a href=\"http:\/\/blog.systemconnect.dk\/?p=1010\">L\u00e6s\u00a0evt. mere her<\/a>!<\/p>\n","protected":false},"excerpt":{"rendered":"<p>Ber\u00f8mte (og\u00a0mere eller mindre korrekte, men sjove historiske citater) inkluderer: &#8220;Everything that can be invented has been invented&#8221; Charles Holland Duell I, Kommis\u00e6r for United States Patent and Trademark Office (1902) &#8220;Two Years from Now, Spam will be solved&#8221; Bill &hellip; <a href=\"https:\/\/scblog.lynge.org\/?p=247\">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":[37,6,4],"tags":[30,15,43,13,22,11,29,53,14,21,7],"class_list":["post-247","post","type-post","status-publish","format-standard","hentry","category-klassisk-c5","category-klassisk-c5-support","category-klassisk-c5-teknik","tag-bug","tag-business-solutions","tag-c5","tag-damgaard-data","tag-database","tag-dynamics","tag-fejl","tag-klassisk-c5","tag-microsoft","tag-native","tag-versioner"],"_links":{"self":[{"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts\/247","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=247"}],"version-history":[{"count":25,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts\/247\/revisions"}],"predecessor-version":[{"id":1016,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=\/wp\/v2\/posts\/247\/revisions\/1016"}],"wp:attachment":[{"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Fmedia&parent=247"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Fcategories&post=247"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/scblog.lynge.org\/index.php?rest_route=%2Fwp%2Fv2%2Ftags&post=247"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}