<?xml version="1.0" encoding="UTF-8"?><rss xmlns:dc="http://purl.org/dc/elements/1.1/" xmlns:content="http://purl.org/rss/1.0/modules/content/" xmlns:atom="http://www.w3.org/2005/Atom" version="2.0" xmlns:cc="http://cyber.law.harvard.edu/rss/creativeCommonsRssModule.html">
    <channel>
        <title><![CDATA[Stories by 阿仁 on Medium]]></title>
        <description><![CDATA[Stories by 阿仁 on Medium]]></description>
        <link>https://medium.com/@louis378?source=rss-1573b9895b0f------2</link>
        <image>
            <url>https://cdn-images-1.medium.com/fit/c/150/150/0*nowgsDnZQatoaFnH.PNG</url>
            <title>Stories by 阿仁 on Medium</title>
            <link>https://medium.com/@louis378?source=rss-1573b9895b0f------2</link>
        </image>
        <generator>Medium</generator>
        <lastBuildDate>Tue, 17 Nov 2026 06:31:26 GMT</lastBuildDate>
        <atom:link href="https://medium.com/@louis378/feed" rel="self" type="application/rss+xml"/>
        <webMaster><![CDATA[yourfriends@medium.com]]></webMaster>
        <atom:link href="http://medium.superfeedr.com/" rel="hub"/>
        <item>
            <title><![CDATA[[JavaScript][DataTables]取得Filter後的DataRows]]></title>
            <link>https://louis378.medium.com/javascript-datatables-%E5%8F%96%E5%BE%97filter%E5%BE%8C%E7%9A%84datarows-f315be6392e3?source=rss-1573b9895b0f------2</link>
            <guid isPermaLink="false">https://medium.com/p/f315be6392e3</guid>
            <category><![CDATA[javascript]]></category>
            <category><![CDATA[datatables]]></category>
            <dc:creator><![CDATA[阿仁]]></dc:creator>
            <pubDate>Fri, 17 Jun 2022 07:49:14 GMT</pubDate>
            <atom:updated>2022-06-17T07:49:14.320Z</atom:updated>
            <content:encoded><![CDATA[<p>在引入DataTables套件之後，出現一個需求，要能夠取到已經做過Search之後的DataRows。</p><blockquote>這個需求能如何達到呢？</blockquote><p>原先是打算就直接寫JS來抓，後來發現他的SourceData其實不會跟著Search功能做連動。想想也算正常，畢竟JS是前端的語言。</p><p>值得慶幸的是，其實DataTables套件本身就有提供對應的Options了。</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/8e3973ceda377475150d1d431a021bf6/href">https://medium.com/media/8e3973ceda377475150d1d431a021bf6/href</a></iframe><p>search有提供三個Options：<br>none (default) - Do not take searching into account (i.e. all rows are used)<br>applied - Use only rows which match the current search applied to the table<br>removed - Use only rows that have been removed from the table by the search applied.</p><blockquote>OK, That’s it, 打完收工 :)</blockquote><p>Reference</p><p><a href="https://datatables.net/reference/type/selector-modifier">https://datatables.net/reference/type/selector-modifier</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=f315be6392e3" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[[Java] Installing OpenJDK 1.8 get error code 2502/2503]]></title>
            <link>https://louis378.medium.com/java-installing-openjdk-1-8-get-error-code-2502-2503-4cf8494a5955?source=rss-1573b9895b0f------2</link>
            <guid isPermaLink="false">https://medium.com/p/4cf8494a5955</guid>
            <category><![CDATA[jdk]]></category>
            <category><![CDATA[java]]></category>
            <dc:creator><![CDATA[阿仁]]></dc:creator>
            <pubDate>Fri, 17 Jun 2022 03:11:15 GMT</pubDate>
            <atom:updated>2022-06-17T03:11:15.589Z</atom:updated>
            <content:encoded><![CDATA[<p>在安裝 Java 的 OpenJDK時，要安裝成功時，跳出了 Error Code: 2502/2503。</p><p>會出現這個問題主要是因為C:\Windows\TEMP目錄下所給的權限不足導致。<br>只要在此目錄下針對Administrator與User帳號的安全性給完全控制，<br>然後再重新安裝就可以了。</p><p>Reference</p><p><a href="https://kb.foxitsoftware.com/hc/en-us/articles/360040660391-Fix-Error-2502-and-2503-while-installing-or-uninstalling">Fix Error 2502 and 2503 while installing or uninstalling</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=4cf8494a5955" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[Using ExternalSQL on Business Central]]></title>
            <link>https://louis378.medium.com/using-externalsql-on-business-central-862d9c6f8ffb?source=rss-1573b9895b0f------2</link>
            <guid isPermaLink="false">https://medium.com/p/862d9c6f8ffb</guid>
            <category><![CDATA[business-central]]></category>
            <category><![CDATA[externalsql]]></category>
            <dc:creator><![CDATA[阿仁]]></dc:creator>
            <pubDate>Wed, 26 Jan 2022 09:11:25 GMT</pubDate>
            <atom:updated>2022-01-26T09:11:25.038Z</atom:updated>
            <content:encoded><![CDATA[<p><strong>Step 1.<br></strong>先將DB中對應需的View建立起來。<br>若使用到extends的Table，記得先將Table Join起來，才取的到對應欄位。</p><p>PS: 需注意在BC中，如果是extends出來的Table，在DB裡面Table的名稱會與原本的Base Table一模一樣，但是對應的後綴ID會不同。</p><p><strong>Step 2.<br></strong>在AL Code中新增對應的Table。加註幾個條件：<br>TableType = ExternalSQL<br>ExternalName = ‘test_view’; //這裡要跟你Create出來的View名稱一樣才行。<br>ExternalSchema = ‘dbo’;</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/656/1*jLzLVDLl7yo9lvLoDUrdpQ.png" /></figure><p><strong>Step 3.<br></strong>在使用前，記得都須加上註冊連線的動作。<br>以Page為例，要在 OnInit() 的 tigger中，建立連線。</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/1024/1*CJaM0W4znGvswWVPBOE3_Q.png" /></figure><p><strong>Reference</strong></p><p><a href="https://demiliani.com/2019/12/17/linkedobjects-on-dynamics-365-business-central-be-careful-now/">https://demiliani.com/2019/12/17/linkedobjects-on-dynamics-365-business-central-be-careful-now/</a><br><a href="https://docs.microsoft.com/en-us/dynamics-nav/external-tables">https://docs.microsoft.com/en-us/dynamics-nav/external-tables</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=862d9c6f8ffb" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[[SQL Server] 透過Link Server 跑遠端Oracle的Store Procedure]]></title>
            <link>https://louis378.medium.com/sql-server-%E9%80%8F%E9%81%8Elink-server-%E8%B7%91%E9%81%A0%E7%AB%AForacle%E7%9A%84store-procedure-8ea414f30a1e?source=rss-1573b9895b0f------2</link>
            <guid isPermaLink="false">https://medium.com/p/8ea414f30a1e</guid>
            <category><![CDATA[oracle]]></category>
            <category><![CDATA[stored-procedure]]></category>
            <category><![CDATA[link-server]]></category>
            <category><![CDATA[sql-server]]></category>
            <dc:creator><![CDATA[阿仁]]></dc:creator>
            <pubDate>Thu, 21 Oct 2021 02:41:44 GMT</pubDate>
            <atom:updated>2021-10-21T02:52:47.196Z</atom:updated>
            <content:encoded><![CDATA[<p>最近有個需求想要讓SQL Server能夠Run Oracle對應的Store Procedure。<br>步驟如下：</p><p><strong>Step 1. </strong><br>首先需要先解封印，開啟Link Server的RPC out功能。<br>(這個功能基於安全考量，Link Server建立時預設是False)<br>可以直接從SSMS Link Server的管理介面中設定。</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/698/1*39hYERT3IBakpWW3C5ve1w.png" /></figure><p><strong>Step 2.</strong><br>使用EXEC指令跑對應的Oracle Store Procedure.</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/1357e2cf8e83bef0d15e52dcec0dd6bc/href">https://medium.com/media/1357e2cf8e83bef0d15e52dcec0dd6bc/href</a></iframe><p><strong>Reference</strong></p><ul><li><a href="https://blog.darkthread.net/blog/sql-linked-server-rpc-out/">【茶包射手筆記】SQL 錯誤－Server &#39;XXX&#39; is not configured for RPC-黑暗執行緒</a></li><li><a href="https://docs.microsoft.com/en-us/archive/blogs/jason_howell/what-is-the-rpc-and-rpc-out-option-on-a-sql-server-linked-server?WT.mc_id=DOP-MVP-37580">What is the RPC and RPC Out option on a SQL Server linked-server?</a></li><li><a href="https://docs.microsoft.com/en-us/previous-versions/sql/sql-server-2008-r2/ms186839(v=sql.105)">Linked Server Properties (Server Options Page)</a></li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=8ea414f30a1e" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[[ASP.NET] woff2字形檔404 Not Found]]></title>
            <link>https://louis378.medium.com/asp-net-woff2%E5%AD%97%E5%BD%A2%E6%AA%94404-not-found-7c4cbb0b5820?source=rss-1573b9895b0f------2</link>
            <guid isPermaLink="false">https://medium.com/p/7c4cbb0b5820</guid>
            <category><![CDATA[aspnet]]></category>
            <dc:creator><![CDATA[阿仁]]></dc:creator>
            <pubDate>Tue, 27 Apr 2021 02:58:29 GMT</pubDate>
            <atom:updated>2021-04-27T02:58:29.557Z</atom:updated>
            <content:encoded><![CDATA[<p>在IIS上面，出現這個問題，字型檔副檔名.woff可以讀的到，但是.woff2的檔案卻都access deny。</p><p>上網查了之後，發現主要原因是因為IIS預設會去鎖住一些非預期的檔案，解法就是修正web.conf檔，新增下面這段。</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/6488b3fc99ea05014933445efdb6e53e/href">https://medium.com/media/6488b3fc99ea05014933445efdb6e53e/href</a></iframe><p>Tip：加上&lt;minMap/&gt;之前，記得先放上&lt;remove/&gt;，避免與IIS預設檔案衝突了。</p><p>Reference</p><ul><li><a href="https://hotcakescommerce.zendesk.com/hc/en-us/articles/210926903-HTTP-404-Not-Found-Error-with-woff-or-woff2-Font-Files">HTTP 404 Not Found Error with .woff or .woff2 Font Files</a></li><li><a href="https://dotblogs.com.tw/libtong/2018/01/05/104025">分享是一種學習</a></li></ul><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=7c4cbb0b5820" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[[SQL] 取欄位值超過小數點後兩位的資料]]></title>
            <link>https://louis378.medium.com/sql-%E5%8F%96%E6%AC%84%E4%BD%8D%E5%80%BC%E8%B6%85%E9%81%8E%E5%B0%8F%E6%95%B8%E9%BB%9E%E5%BE%8C%E5%85%A9%E4%BD%8D%E7%9A%84%E8%B3%87%E6%96%99-b6660b486002?source=rss-1573b9895b0f------2</link>
            <guid isPermaLink="false">https://medium.com/p/b6660b486002</guid>
            <category><![CDATA[sql]]></category>
            <dc:creator><![CDATA[阿仁]]></dc:creator>
            <pubDate>Thu, 18 Feb 2021 08:06:47 GMT</pubDate>
            <atom:updated>2021-02-18T08:06:47.977Z</atom:updated>
            <content:encoded><![CDATA[<iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/b19fe214ac6b910e607ecf2d58ab962e/href">https://medium.com/media/b19fe214ac6b910e607ecf2d58ab962e/href</a></iframe><p>原理其實很簡單，把該欄位的值*100與該欄位*100後轉整數的值相減。<br>不為0的就是了。</p><p><strong>Reference<br></strong><a href="https://stackoverflow.com/questions/32462644/select-numbers-with-more-than-4-decimal-places">https://stackoverflow.com/questions/32462644/select-numbers-with-more-than-4-decimal-places</a></p><p><a href="https://stackoverflow.com/questions/3418606/sql-how-do-i-get-only-the-numbers-after-the-decimal">https://stackoverflow.com/questions/3418606/sql-how-do-i-get-only-the-numbers-after-the-decimal</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=b6660b486002" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[[windows] 遠端桌面多螢幕顯示]]></title>
            <link>https://louis378.medium.com/windows-%E9%81%A0%E7%AB%AF%E6%A1%8C%E9%9D%A2%E5%A4%9A%E8%9E%A2%E5%B9%95%E9%A1%AF%E7%A4%BA-6b3a04fbd59f?source=rss-1573b9895b0f------2</link>
            <guid isPermaLink="false">https://medium.com/p/6b3a04fbd59f</guid>
            <category><![CDATA[rdp]]></category>
            <category><![CDATA[windows]]></category>
            <dc:creator><![CDATA[阿仁]]></dc:creator>
            <pubDate>Wed, 10 Feb 2021 06:07:50 GMT</pubDate>
            <atom:updated>2021-02-10T06:07:50.807Z</atom:updated>
            <content:encoded><![CDATA[<blockquote><strong>什麼~ 原來遠端桌面也支援多螢幕顯示的功能！</strong></blockquote><p>作法很簡單，遠端桌面前，把這個勾勾打開就可以了。</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/421/0*x6Hlyf-dYYxvAnfO.png" /><figcaption>開啟 Use all my monitors</figcaption></figure><p><strong>Reference<br></strong><a href="https://blog.darkthread.net/blog/multidisp-remote-desktop/">https://blog.darkthread.net/blog/multidisp-remote-desktop/</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=6b3a04fbd59f" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[[jQuery] 釋放 jQuery 的 $ 變數]]></title>
            <link>https://louis378.medium.com/jquery-%E9%87%8B%E6%94%BE-jquery-%E7%9A%84-%E8%AE%8A%E6%95%B8-a6dc5e689639?source=rss-1573b9895b0f------2</link>
            <guid isPermaLink="false">https://medium.com/p/a6dc5e689639</guid>
            <category><![CDATA[jquery]]></category>
            <dc:creator><![CDATA[阿仁]]></dc:creator>
            <pubDate>Tue, 09 Feb 2021 07:18:33 GMT</pubDate>
            <atom:updated>2021-02-09T07:18:33.911Z</atom:updated>
            <content:encoded><![CDATA[<p>正常我們在使用 jQuery 時，會很習慣使用他內建的快捷變數 $。<br>因為簡單方便，打一個字就好了，不用把整個 jQuery 都打出來。</p><blockquote>但是 JS 有很多 Library，<br>假設其他 Library 也用到 $ 做為快捷變數，悲劇就發生了…</blockquote><p>為此 jQuery 已經幫你設想到，只要使用 jQuery 的一個函式 jQuery.noConflict(); 就OK拉。</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/b332f6d7d0061ae6b21c72e08b787241/href">https://medium.com/media/b332f6d7d0061ae6b21c72e08b787241/href</a></iframe><h3>Reference</h3><p><a href="https://api.jquery.com/jquery.noconflict/">https://api.jquery.com/jquery.noconflict/</a><br><a href="https://www.w3schools.com/jquery/jquery_noconflict.asp">https://www.w3schools.com/jquery/jquery_noconflict.asp</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=a6dc5e689639" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[[MySQL] FEDERATED Table]]></title>
            <link>https://louis378.medium.com/mysql-federated-table-7894edd25e5f?source=rss-1573b9895b0f------2</link>
            <guid isPermaLink="false">https://medium.com/p/7894edd25e5f</guid>
            <category><![CDATA[mysql]]></category>
            <category><![CDATA[federated]]></category>
            <dc:creator><![CDATA[阿仁]]></dc:creator>
            <pubDate>Mon, 08 Feb 2021 03:38:03 GMT</pubDate>
            <atom:updated>2021-02-08T03:39:56.916Z</atom:updated>
            <content:encoded><![CDATA[<p>正常用習慣MS SQL或是Oracle的DB Link功能之後，通常都會覺得很方便。於是就找看看MySQL有沒有提供類似的功能。所以發現了這個 <strong>Federated Table</strong>。</p><p>他的功能跟DB Link類似，就是讓你可以去存取更新Remote DB的內容，只是他跟DB Link還是有點差別，他是Table Mapping，DB Link是DB Mapping。</p><p>意思就是，我們用DB Link的時候，建好Link Server之後，就可以直接調用Remote的資源了，但是Federated Table因為他是Table Mapping，所以你要針對你需要使用的Table去建立對應的Table Schema才能使用。</p><p><strong>Step1. 開啟MySQL Federated 功能</strong></p><p>先使用show engines;來查看MySQL對 Federated引擎的支援狀況。</p><figure><img alt="" src="https://cdn-images-1.medium.com/max/648/1*H0voN7OKTv7t0NR0rU261g.png" /></figure><p>如果顯示YES表示已經開啟，若顯示No，記得至MySQL設定檔my.cnf中加上這行。</p><pre>[mysqld]<br>federated</pre><p>記得重啟MySQL。</p><p><strong>Step2. 建立好對應的Remote Server別名</strong></p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/50c76c804ade36d2ca994b0abbef0e7c/href">https://medium.com/media/50c76c804ade36d2ca994b0abbef0e7c/href</a></iframe><p><strong>Step3. 建立對應的Federated Table</strong></p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/1f8bc904de5d277fb19b2587d01eb68b/href">https://medium.com/media/1f8bc904de5d277fb19b2587d01eb68b/href</a></iframe><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=7894edd25e5f" width="1" height="1" alt="">]]></content:encoded>
        </item>
        <item>
            <title><![CDATA[[SQL Server] 檢查DB Lock的狀態]]></title>
            <link>https://louis378.medium.com/sql-server-%E6%AA%A2%E6%9F%A5db-lock%E7%9A%84%E7%8B%80%E6%85%8B-fd9b74d8d0a?source=rss-1573b9895b0f------2</link>
            <guid isPermaLink="false">https://medium.com/p/fd9b74d8d0a</guid>
            <category><![CDATA[sql-server]]></category>
            <dc:creator><![CDATA[阿仁]]></dc:creator>
            <pubDate>Thu, 28 Jan 2021 09:39:21 GMT</pubDate>
            <atom:updated>2021-01-28T09:39:21.882Z</atom:updated>
            <content:encoded><![CDATA[<p>我們都知道DB在使用的時候，有時候會出現Table Lock的問題。</p><p>正常可以使用MS SQL官方所提供的指令來看目前正在Run的程序</p><pre>EXCE sp_who;<br>EXCE sp_who2;</pre><p>可以用下面這段語法查詢出資料庫中Lock的狀態</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/181ebca2cc6ce85050789ed97983622c/href">https://medium.com/media/181ebca2cc6ce85050789ed97983622c/href</a></iframe><p>這個是可以看到目前正在執行的完整SQL指令</p><iframe src="" width="0" height="0" frameborder="0" scrolling="no"><a href="https://medium.com/media/e6f3c79b9c75e7a2b8dfa419a2f54faf/href">https://medium.com/media/e6f3c79b9c75e7a2b8dfa419a2f54faf/href</a></iframe><p><strong>Reference</strong></p><p><a href="https://dotblogs.com.tw/AlenWu_coding_blog/2017/06/03/sql_lock_check">AlenWu的程式學習筆記</a></p><p><a href="https://blog.miniasp.com/post/2010/10/13/How-to-get-current-executing-statements-in-SQL-Server#continue">https://blog.miniasp.com/post/2010/10/13/How-to-get-current-executing-statements-in-SQL-Server#continue</a></p><img src="https://medium.com/_/stat?event=post.clientViewed&referrerSource=full_rss&postId=fd9b74d8d0a" width="1" height="1" alt="">]]></content:encoded>
        </item>
    </channel>
</rss>