{"id":5355,"date":"2020-11-27T13:48:52","date_gmt":"2020-11-27T04:48:52","guid":{"rendered":"https:\/\/www.climb.co.jp\/blog_dbmoto\/?p=5355"},"modified":"2025-08-20T18:15:17","modified_gmt":"2025-08-20T09:15:17","slug":"syniti-data-replication-%e6%97%a7dbmoto%e3%81%a7%e3%81%ae%e3%82%b9%e3%82%af%e3%83%aa%e3%83%97%e3%83%88%e3%81%ae%e6%9b%b8%e3%81%8d%e6%96%b9%e2%91%a4%ef%bc%9a%e3%83%95%e3%82%a3%e3%83%bc%e3%83%ab","status":"publish","type":"post","link":"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/5355","title":{"rendered":"Syniti Data Replication (\u65e7DBMoto)\u3067\u306e\u30b9\u30af\u30ea\u30d7\u30c8\u306e\u66f8\u304d\u65b9\u2464\uff1a\u30d5\u30a3\u30fc\u30eb\u30c9\u30de\u30c3\u30d4\u30f3\u30b0\u95a2\u6570\u306e\u66f8\u304d\u65b9"},"content":{"rendered":"\n<p>\u3053\u306e\u30bf\u30a4\u30d7\u306e\u95a2\u6570\u3067\u306f\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u5b9a\u7fa9\u3059\u308b\u969b\u306e\u3001\u30d5\u30a3\u30fc\u30eb\u30c9\uff08\u30ab\u30e9\u30e0\uff09\u30de\u30c3\u30d4\u30f3\u30b0\u306e\u30bd\u30fc\u30b9\u5217\u3068\u30bf\u30fc\u30b2\u30c3\u30c8\u5217\u3092\u8b58\u5225\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306e\u52d5\u4f5c\u306f\u30bd\u30fc\u30b9\u30c6\u30fc\u30d6\u30eb\u3068\u30bf\u30fc\u30b2\u30c3\u30c8\u30c6\u30fc\u30d6\u30eb\u306e\u30ab\u30e9\u30e0\u306e\u4e00\u81f4\u3059\u308b\u540d\u524d\u3092\u5bfe\u5fdc\u4ed8\u3051\u3057\u307e\u3059\u3002<\/p>\n\n\n\n<h2 class=\"wp-block-heading\">\u30de\u30c3\u30d4\u30f3\u30b0\u30eb\u30fc\u30eb\u306e\u5b9f\u88c5<\/h2>\n\n\n\n<ol class=\"wp-block-list\"><li>\u30b0\u30ed\u30fc\u30d0\u30eb\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u4f5c\u6210\u3059\u308b\u30e1\u30bf\u30c7\u30fc\u30bf\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/li><li>\u30de\u30a6\u30b9\u306e\u53f3\u30dc\u30bf\u30f3\u30e1\u30cb\u30e5\u30fc\u304b\u3089\u3001[<strong>\u30b0\u30ed\u30fc\u30d0\u30eb\u30b9\u30af\u30ea\u30d7\u30c8<\/strong>]\u3092\u9078\u629e\u3057\u307e\u3059\u3002<\/li><li>\u30b0\u30ed\u30fc\u30d0\u30eb\u30b9\u30af\u30ea\u30d7\u30c8\u30a8\u30c7\u30a3\u30bf\u3067\u3001\u30de\u30c3\u30d4\u30f3\u30b0\u30fb\u30eb\u30fc\u30eb\u3092\u4ee5\u4e0b\u306b\u8ffd\u52a0\u3057\u307e\u3059\u3002<br>VB.NET: Public Class MappingRule : Inherits IMappingRule<br>C#: public class MappingRule : IMappingRule<\/li><li>MappingRuleAttribute\u5b9a\u7fa9\u3057\u307e\u3059\u3002\u3053\u306e\u5b9a\u7fa9\u306f\u30d5\u30a3\u30fc\u30eb\u30c9\u3092\u30de\u30c3\u30d4\u30f3\u30b0\u3092\u6307\u5b9a\u3059\u308b\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30a6\u30a3\u30b6\u30fc\u30c9\u3084\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u30d7\u30ed\u30d1\u30c6\u30a3\u306e\u30de\u30c3\u30d4\u30f3\u30b0\u3067\u8868\u793a\u3055\u308c\u307e\u3059\u3002\u4e00\u3064\u76ee\u306e\u6587\u5b57\u5217\u306f\u30ab\u30b9\u30bf\u30e0\u30de\u30c3\u30d4\u30f3\u30b0\u306e\u30b5\u30d6\u30e1\u30cb\u30e5\u30fc\u3067\u8868\u793a\u3055\u308c\u308b\u30c6\u30ad\u30b9\u30c8\u3001\u4e8c\u3064\u76ee\u306e\u6587\u5b57\u5217\u306f\u95a2\u6570\u306e\u30c4\u30fc\u30eb\u30c1\u30c3\u30d7\u306e\u8aac\u660e\u3068\u3057\u3066\u8868\u793a\u3055\u308c\u307e\u3059\u3002<\/li><li>\u4ee5\u4e0b\u306e\u4f8b\u306e\u3088\u3046\u306b\u3001\u95a2\u6570\u3092\u8a18\u8ff0\u3057\u307e\u3059\u3002\u95a2\u6570\u306e\u30d1\u30e9\u30e1\u30fc\u30bf\u30fc\u306f\u3001\u4ee5\u4e0b\u306e\u4f8b\u306e\u30d1\u30e9\u30e1\u30fc\u30bf\u30fc\u3068\u4e00\u81f4\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3059\u3002\u3053\u308c\u3089\u306e\u30d1\u30e9\u30e1\u30fc\u30bf\u30fc\u306f\u3001\u95a2\u6570\u3067\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002<\/li><li>\u30b0\u30ed\u30fc\u30d0\u30eb\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u30b3\u30f3\u30d1\u30a4\u30eb\u3057\u3066\u3001\u95a2\u6570\u304c\u6b63\u3057\u304f\u30b3\u30f3\u30d1\u30a4\u30eb\u3055\u308c\u308b\u3053\u3068\u3092\u78ba\u8a8d\u3057\u307e\u3059\u3002\u6b63\u3057\u304f\u30b3\u30f3\u30d1\u30a4\u30eb\u3055\u308c\u305f\u5834\u5408\u306b\u306e\u307f\u3001[\u81ea\u52d5\u30de\u30c3\u30d4\u30f3\u30b0]\u30e1\u30cb\u30e5\u30fc\u3067\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002<\/li><\/ol>\n\n\n\n<h2 class=\"wp-block-heading\">\u30d5\u30a3\u30fc\u30eb\u30c9\u30de\u30c3\u30d4\u30f3\u30b0\u95a2\u6570\u306e\u4f8b<\/h2>\n\n\n\n<p>\u4ee5\u4e0b\u306e\u4f8b\u3067\u306f\u30bd\u30fc\u30b9\u30c6\u30fc\u30d6\u30eb\u3001\u30bf\u30fc\u30b2\u30c3\u30c8\u30c6\u30fc\u30d6\u30eb\u306e\u30ab\u30e9\u30e0\u3044\u305a\u308c\u304b\u306b4\u6587\u5b57\u306e\u63a5\u982d\u8f9e\u304c\u4f7f\u7528\u3055\u308c\u3066\u3044\u308b\u5834\u5408\u306b\u3001\u305d\u306e\u63a5\u982d\u8f9e\u3092\u30b9\u30ad\u30c3\u30d7\u3057\u3001\u540d\u524d\u3092\u6bd4\u8f03\u3059\u308b\u305f\u3081\u306e\u95a2\u6570\u3092\u4f5c\u6210\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n\n\n\n<h3 class=\"wp-block-heading\">VB.NET\u306e\u4f8b<\/h3>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: vb; title: ; notranslate\" title=\"\">\nPublic Class MappingRule : Inherits IMappingRule\n\t&lt;MappingRuleAttribute(&quot;Match By Target Prefix&quot;, &quot;\u30bf\u30fc\u30b2\u30c3\u30c8\u306e\u63a5\u982d\u8f9e&#039;fld_&#039;\u3092\u8003\u616e\u3057\u3066\u540d\u524d\u3092\u4e00\u81f4&quot;)&gt;\n\tPublic Function CustomMapping_ByNameTPrefixed (\n\t\t\tByVal sSourceName As String,\n\t\t\tByVal iSourceOrdinal As Integer,\n\t\t\tByVal sTargetName As String,\n\t\t\tByVal iTargetOrdinal As Integer) As Boolean\n           If sTargetName.Length &gt;= 4 Then\n\t\tReturn (String.Compare(sSourceName, sTargetName.SubString(4), True) = 0)\n\t    Else\n\t\tReturn False\n\t    End If\n\tEnd Function\n      \n\t&lt;MappingRuleAttribute(&quot;Match By Source Preffix&quot;, &quot;\u30bd\u30fc\u30b9\u306e\u63a5\u982d\u8f9e&#039;fld_&#039;\u3092\u8003\u616e\u3057\u3066\u540d\u524d\u3092\u4e00\u81f4&quot;)&gt;\n\tPublic Function CustomMapping_ByNameSPrefixed (\n\t\t\tByVal sSourceName As String,\n\t\t\tByVal iSourceOrdinal As Integer,\n\t\t\tByVal sTargetName As String,\n\t\t\tByVal iTargetOrdinal As Integer) As Boolean\n\t   If sSourceName.Length &gt;= 4\n\t\tReturn (String.Compare(sSourceName.SubString(4), sTargetName, True) = 0)\n\t   Else\n\t\tReturn False\n\t   End If\n\tEnd Function    \n \n\t&lt;MappingRuleAttribute(&quot;Match Custom&quot;, &quot;\u7279\u5b9a\u306e\u30ab\u30b9\u30bf\u30e0\u30eb\u30fc\u30eb\u3092\u8003\u616e\u3057\u3066\u540d\u524d\u3092\u4e00\u81f4&quot;)&gt;\n\tPublic Function MyCustomMapping (\n\t\t\tByVal bIsForth As Boolean,\n\t\t\tByVal sSourceName As String,\n\t\t\tByVal iSourceOrdinal As Integer,\n\t\t\tByVal sSourceType As String,\n\t\t\tByVal sTargetName As String,\n\t\t\tByVal iTargetOrdinal As Integer,\n\t\t\tByVal sTargetType As String,\n\t\t\tByRef sExpression As System.Text.StringBuilder) As Boolean\n\t\t\t\/\/\/     ...\n\tEnd Function\n\t&lt;MappingRuleAttribute(&quot;Match Custom Extended Params&quot;, &quot;\u7279\u5b9a\u306e\u30ab\u30b9\u30bf\u30e0\u30eb\u30fc\u30eb\u3092\u8003\u616e\u3057\u3066\u540d\u524d\u3092\u4e00\u81f4&quot;)&gt;\n\tPublic Function MyCustomMapping (\n\t\t\tByVal bIsForth As Boolean,\n\t\t\tByVal sSourceName As String,\n\t\t\tByVal iSourceOrdinal As Integer,\n\t\t\tByVal sSourceType As String,\n\t\t\tByVal bIsSourcePrimaryKey As Boolean,\n\t\t\tByVal bIsSourceNullable As Boolean,   \n\t\t\tByVal iSourceSize As Integer,\n\t\t\tByVal sSourcePrecision As Short,\n\t\t\tByVal sSourceScale As Short,\n\t\t\tByVal sTargetName As String,\n\t\t\tByVal iTargetOrdinal As Integer,\n\t\t\tByVal sTargetType As String,\n\t\t\tByVal bIsTargetPrimaryKey As Boolean,\n\t\t\tByVal bIsTargetNullable As Boolean,\n\t\t\tByVal iTargetSize As Integer,\n\t\t\tByVal sTargetPrecision As Short,\n\t\t\tByVal sTargetScale As Short,\n\t\t\tByRef sExpression As System.Text.StringBuilder) As Boolean\n\t\t\t\/\/\/     ...\n\tEnd Function\nEnd Class\t\t\n<\/pre><\/div>\n\n\n<h3 class=\"wp-block-heading\">C#\u306e\u4f8b<\/h3>\n\n\n<div class=\"wp-block-syntaxhighlighter-code \"><pre class=\"brush: csharp; title: ; notranslate\" title=\"\">\nusing System;\nusing System.Data;\nusing DBMotoPublic;\nusing DBMotoScript;\nnamespace DBRS\n{\n   public class GlobalScript : IGlobalScript\n   {\n   }\n   public class MappingRule : IMappingRule\n   {\n     &#x5B;MappingRuleAttribute(&quot;Match By Target Prefix&quot;, &quot;\u30bf\u30fc\u30b2\u30c3\u30c8\u306e\u63a5\u982d\u8f9e&#039;fld_&#039;\u3092\u8003\u616e\u3057\u3066\u540d\u524d\u3092\u4e00\u81f4&quot;)]\n     public bool CustomMapping_ByNameTPrefixed (String sSourceName, int iSourceOrdinal, String sTargetName, int iTargetOrdinal)\n\t{\n\t   if (sTargetName.Length &gt;= 4)\n\t      {\n\t\treturn (String.Compare(sSourceName, sTargetName.Substring(4), true) == 0);\n\t       }\n\t   else\n\t       {\n\t\treturn false;\n\t        }\n\t}\n    \n\t&#x5B;MappingRuleAttribute(&quot;Match By Source Prefix&quot;, &quot;\u30bd\u30fc\u30b9\u306e\u63a5\u982d\u8f9e&#039;fld_&#039;\u3092\u8003\u616e\u3057\u3066\u540d\u524d\u3092\u4e00\u81f4&quot;)]\n\tpublic bool CustomMapping_ByNameSuffixed (String sSourceName, int iSourceOrdinal, String sTargetName, int iTargetOrdinal)\n\t{\n\t   if (sSourceName.Length &gt;= 4)\n\t\t{\n\t\t   return (String.Compare(sSourceName.Substring(4), sTargetName, true) == 0);\n\t\t}\n\t   else\n\t\t{\n\t\t   return false;\n\t\t}\n\t  }\n\t&#x5B;MappingRuleAttribute(&quot;Match Custom&quot;, &quot;\u7279\u5b9a\u306e\u30ab\u30b9\u30bf\u30e0\u30eb\u30fc\u30eb\u3092\u8003\u616e\u3057\u3066\u540d\u524d\u3092\u4e00\u81f4&quot;)]\n\tpublic bool MyCustomMapping(bool bIsForth, String sSourceName, int iSourceOrdinal, String sSourceType, \n          String sTargetName, int iTargetOrdinal, String sTargetType, ref System.Text.StringBuilder sExpression)\n\t{\n\t  \/\/      ...\n\t  return true;\n\t}\n   }\n   public class GlobalEvents : IGlobalEvents\n   {\n   }\n}\n<\/pre><\/div>\n\n\n<h2 class=\"wp-block-heading\">\u30d1\u30e9\u30e1\u30fc\u30bf\u4e00\u89a7<\/h2>\n\n\n\n<p>\u95a2\u6570\u3067\u5229\u7528\u3067\u304d\u308b\u30d1\u30e9\u30e1\u30fc\u30bf\u306f\u4ee5\u4e0b\u306e\u901a\u308a\u3067\u3059\u3002<\/p>\n\n\n\n<figure class=\"wp-block-table is-style-regular\"><table><tbody><tr><td><strong>\u30d1\u30e9\u30e1\u30fc\u30bf<\/strong><\/td><td><strong>\u8aac\u660e<\/strong><\/td><\/tr><tr><td><strong>bIsForth<\/strong>\u00a0<\/td><td>\u30b7\u30f3\u30af\u30ed\u30ca\u30a4\u30bc\u30fc\u30b7\u30e7\u30f3\u306b\u304a\u3051\u308b\u30de\u30c3\u30d4\u30f3\u30b0\u3067\u9806\u65b9\u5411\u3067\u3042\u308c\u3070\u3001TRUE\u3001\u9006\u65b9\u5411\u3067\u3042\u308c\u3070FALSE\u3092\u4f7f\u7528\u3002<br>\u305f\u3068\u3048\u3070\u3001bIsForth\u304cTrue\u306e\u5834\u5408\u3001\u540d\u524d\u3067\u30de\u30c3\u30d4\u30f3\u30b0\u3092\u9069\u7528\u3001bIsForth\u304cFalse\u306e\u5834\u5408\u306f\u3001\u5225\u306e\u30eb\u30fc\u30eb\u3092\u9069\u7528\u3059\u308b\u3068\u3044\u3046\u3088\u3046\u306b\u3001\u3053\u308c\u306b\u3088\u308a\u3001\u30de\u30c3\u30d4\u30f3\u30b0\u306e\u4e21\u65b9\u5411\u3092\u51e6\u7406\u3059\u308b\u30b9\u30af\u30ea\u30d7\u30c8\u3092\u4f5c\u6210\u3067\u304d\u3001<\/td><\/tr><tr><td><strong>sSourceName<\/strong>\u00a0<\/td><td>\u30bd\u30fc\u30b9\u30ab\u30e9\u30e0\u306e\u540d\u524d<\/td><\/tr><tr><td><strong>iSourceOrdinal<\/strong><\/td><td>\u30bd\u30fc\u30b9\u30ab\u30e9\u30e0\u306e\u9806\u5e8f\u4f4d\u7f6e\uff08\u6574\u6570\uff09<\/td><\/tr><tr><td><strong>sSourceType<\/strong>\u00a0<\/td><td>\u30bd\u30fc\u30b9\u30ab\u30e9\u30e0\u306e\u30bf\u30a4\u30d7\uff08\u5143\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30bf\u30a4\u30d7\uff09\u3002<br>\u305f\u3068\u3048\u3070\u3001\u3059\u3079\u3066\u306eVARCHAR\u5217\u306e\u30de\u30c3\u30d4\u30f3\u30b0\u306bTrim\u95a2\u6570\u3092\u9069\u7528\u3059\u308b\u3068\u3044\u3063\u305f\u3088\u3046\u306b\u3001\u3053\u308c\u3092\u4f7f\u7528\u3057\u3066\u3001\u7279\u5b9a\u306e\u30c7\u30fc\u30bf\u578b\u3067\u6a5f\u80fd\u3059\u308b\u30ab\u30b9\u30bf\u30e0\u30de\u30c3\u30d4\u30f3\u30b0\u30eb\u30fc\u30eb\u3092\u4f5c\u6210\u3067\u304d\u307e\u3059\u3002<\/td><\/tr><tr><td><strong>bIsSourcePrimaryKey<\/strong>\u00a0<\/td><td>\u30bd\u30fc\u30b9\u30d5\u30a3\u30fc\u30eb\u30c9\u304c\u4e3b\u30ad\u30fc\u3067\u3042\u308b\u304b\u3069\u3046\u304b<\/td><\/tr><tr><td><strong>bIsSourceNullable<\/strong>\u00a0<\/td><td>\u30bd\u30fc\u30b9\u30d5\u30a3\u30fc\u30eb\u30c9\u3067NULL\u304c\u8a31\u53ef\u3055\u308c\u3066\u3044\u308b\u304b\u3069\u3046\u304b<\/td><\/tr><tr><td><strong>iSourceSize<\/strong>\u00a0<\/td><td>\u6574\u6570\u3067\u8868\u3055\u308c\u308b\u30bd\u30fc\u30b9\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u30b5\u30a4\u30ba<\/td><\/tr><tr><td><strong>sSourcePrecision<\/strong>\u00a0<\/td><td>short\u578b\u3067\u8868\u3055\u308c\u308b\u30bd\u30fc\u30b9\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u7cbe\u5ea6<\/td><\/tr><tr><td><strong>sSourceScale<\/strong><\/td><td>short\u578b\u3067\u8868\u3055\u308c\u308b\u30bd\u30fc\u30b9\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u30b9\u30b1\u30fc\u30eb<\/td><\/tr><tr><td><strong>sTargetName<\/strong>\u00a0<\/td><td>\u30bf\u30fc\u30b2\u30c3\u30c8\u30ab\u30e9\u30e0\u306e\u540d\u524d<\/td><\/tr><tr><td><strong>iTargetOrdinal<\/strong>\u00a0<\/td><td>\u30ab\u30e9\u30e0\u306e\u9806\u5e8f\u4f4d\u7f6e\uff08\u6574\u6570\uff09<\/td><\/tr><tr><td><strong>sTargetType<\/strong>\u00a0<\/td><td>\u30bf\u30fc\u30b2\u30c3\u30c8\u30ab\u30e9\u30e0\u306e\u30bf\u30a4\u30d7\uff08\u5143\u306e\u30c7\u30fc\u30bf\u30d9\u30fc\u30b9\u30bf\u30a4\u30d7\uff09<\/td><\/tr><tr><td><strong>blsTargetPrimaryKey<\/strong>\u00a0<\/td><td>\u30bf\u30fc\u30b2\u30c3\u30c8\u30d5\u30a3\u30fc\u30eb\u30c9\u304c\u4e3b\u30ad\u30fc\u3067\u3042\u308b\u304b\u3069\u3046\u304b<\/td><\/tr><tr><td><strong>bIsTargetNullable<\/strong>\u00a0<\/td><td>\u30bf\u30fc\u30b2\u30c3\u30c8\u30d5\u30a3\u30fc\u30eb\u30c9\u3067NULL\u304c\u8a31\u53ef\u3055\u308c\u3066\u3044\u308b\u304b\u3069\u3046\u304b<br>\u30bf\u30fc\u30b2\u30c3\u30c8\u30d5\u30a3\u30fc\u30eb\u30c9\u3067NULL\u304c\u8a31\u53ef\u3055\u308c\u3066\u3044\u308b\u304b\u78ba\u8a8d\u3057\u3001\u8a31\u53ef\u3055\u308c\u3066\u3044\u306a\u3044\u5834\u5408\u306b\u3001NULL\u5024\u304c\u30bf\u30fc\u30b2\u30c3\u30c8\u306b\u6e21\u3055\u308c\u308b\u30b1\u30fc\u30b9\u3092\u56de\u907f\u3067\u304d\u307e\u3059\u3002<\/td><\/tr><tr><td><strong>iTargetSize<\/strong>\u00a0<\/td><td>\u6574\u6570\u3067\u8868\u3055\u308c\u308b\u30bf\u30fc\u30b2\u30c3\u30c8\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u30b5\u30a4\u30ba<\/td><\/tr><tr><td><strong>sTargetPrecision<\/strong>\u00a0<\/td><td>short\u578b\u3067\u8868\u3055\u308c\u308b\u30bf\u30fc\u30b2\u30c3\u30c8\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u7cbe\u5ea6<\/td><\/tr><tr><td><strong>sTargetScale<\/strong>\u00a0<\/td><td>short\u578b\u3067\u8868\u3055\u308c\u308b\u30bf\u30fc\u30b2\u30c3\u30c8\u30d5\u30a3\u30fc\u30eb\u30c9\u306e\u30b9\u30b1\u30fc\u30eb<\/td><\/tr><tr><td><strong>sExpression<\/strong>\u00a0<\/td><td>\u95a2\u6570\u304b\u3089Syniti DR\u3078\u8fd4\u3059\u3053\u3068\u304c\u3067\u304d\u308b\u53c2\u7167\u30d1\u30e9\u30e1\u30fc\u30bf<br>\u3053\u308c\u306b\u3088\u308a\u3001\u7279\u5b9a\u306e\u5f0f\u3092\u30de\u30c3\u30d4\u30f3\u30b0\u306b\u9069\u7528\u3067\u304d\u307e\u3059\u3002<br>\u4ee5\u4e0b\u306e\u4f8b\u3067\u306fVARCHAR\u306e\u3059\u3079\u3066\u306e\u30bf\u30fc\u30b2\u30c3\u30c8\u30ab\u30e9\u30e0\u306b\u5bfe\u3057\u3066\u30b0\u30ed\u30fc\u30d0\u30eb\u95a2\u6570MyGlobalFunction\u3092\u547c\u3073\u51fa\u3059\u5f0f\u3092\u5b9a\u7fa9\u3057\u3066\u3044\u307e\u3059\u3002<br>If sTargetType = &#8220;VARCHAR&#8221; Then<br>sExpression.Append\uff08 &#8220;MyGlobalFunction\uff08[&#8221; + sSourceName + &#8220;]\uff09&#8221;\uff09<br>End If<\/td><\/tr><\/tbody><\/table><\/figure>\n\n\n\n<p><\/p>\n","protected":false},"excerpt":{"rendered":"<p>\u3053\u306e\u30bf\u30a4\u30d7\u306e\u95a2\u6570\u3067\u306f\u30ec\u30d7\u30ea\u30b1\u30fc\u30b7\u30e7\u30f3\u3092\u5b9a\u7fa9\u3059\u308b\u969b\u306e\u3001\u30d5\u30a3\u30fc\u30eb\u30c9\uff08\u30ab\u30e9\u30e0\uff09\u30de\u30c3\u30d4\u30f3\u30b0\u306e\u30bd\u30fc\u30b9\u5217\u3068\u30bf\u30fc\u30b2\u30c3\u30c8\u5217\u3092\u8b58\u5225\u3059\u308b\u305f\u3081\u306b\u4f7f\u7528\u3067\u304d\u307e\u3059\u3002\u30c7\u30d5\u30a9\u30eb\u30c8\u3067\u306e\u52d5\u4f5c\u306f\u30bd\u30fc\u30b9\u30c6\u30fc\u30d6\u30eb\u3068\u30bf\u30fc\u30b2\u30c3\u30c8\u30c6\u30fc\u30d6\u30eb\u306e\u30ab\u30e9\u30e0\u306e\u4e00\u81f4\u3059\u308b\u540d\u524d\u3092\u5bfe\u5fdc\u4ed8 &hellip; <a href=\"https:\/\/www.climb.co.jp\/blog_dbmoto\/archives\/5355\">\u7d9a\u304d\u3092\u8aad\u3080 <span class=\"meta-nav\">&rarr;<\/span><\/a><\/p>\n","protected":false},"author":2,"featured_media":0,"comment_status":"open","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[342,4,217],"tags":[],"class_list":["post-5355","post","type-post","status-publish","format-standard","hentry","category-operation","category-syniti","category-knowledge-base"],"_links":{"self":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/5355","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/users\/2"}],"replies":[{"embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/comments?post=5355"}],"version-history":[{"count":6,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/5355\/revisions"}],"predecessor-version":[{"id":7288,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/posts\/5355\/revisions\/7288"}],"wp:attachment":[{"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/media?parent=5355"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/categories?post=5355"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.climb.co.jp\/blog_dbmoto\/wp-json\/wp\/v2\/tags?post=5355"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}