{"id":6843,"date":"2019-06-12T10:00:04","date_gmt":"2019-06-12T01:00:04","guid":{"rendered":"https:\/\/ywc.com\/filemaker\/?p=6843"},"modified":"2019-06-28T15:39:16","modified_gmt":"2019-06-28T06:39:16","slug":"filemaker-pro-18-advanced-%e3%81%ae%e6%96%b0%e6%a9%9f%e8%83%bd%e3%80%90%e5%86%8d%e5%b8%b0%e8%a8%88%e7%ae%97%e3%81%a7%e3%81%8d%e3%82%8b%e3%80%8cwhile%e3%80%8d%e9%96%a2%e6%95%b0%e3%81%ae%e4%be%bf","status":"publish","type":"post","link":"https:\/\/ywc.com\/filemaker\/?p=6843","title":{"rendered":"FileMaker Pro 18 Advanced \u306e\u65b0\u6a5f\u80fd\u3010\u518d\u5e30\u8a08\u7b97\u3067\u304d\u308b\u300cWhile\u300d\u95a2\u6570\u306e\u4fbf\u5229\u306a\u4f7f\u3044\u65b9\u3011"},"content":{"rendered":"

\u524d\u56de\u306f\u3001\u300cWhile\u300d\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u306e\u57fa\u672c\u3092\u898b\u3066\u307f\u307e\u3057\u305f\u3002<\/h3>\n

 <\/p>\n

\u524d\u56de\u306e\u300cWhile\u300d\u95a2\u6570\u306e\u30d6\u30ed\u30b0: FileMaker Pro 18 Advanced \u306e\u65b0\u6a5f\u80fd\u3000\u3010\u300cWhile\u300d\u95a2\u6570\u30fb\u300cSetRecursion\u300d\u95a2\u6570\u3011<\/a><\/p>\n

 <\/p>\n

\u4eca\u56de\u306f\u3001\u5177\u4f53\u7684\u306a\u4f7f\u7528\u4f8b\u3092\u7d39\u4ecb\u3057\u307e\u3059\u3002<\/h3>\n

 <\/p>\n

\u00a0\u25a1\u25a0 JSON\u30c7\u30fc\u30bf\u306e\u30d1\u30fc\u30b9\u3067\u306e\u300cWhile\u300d\u95a2\u6570 \u25a0\u25a1<\/strong><\/h3>\n

 <\/p>\n

\u5177\u4f53\u7684\u306a\u4f8b\u3068\u3044\u3046\u306e\u306f\u3001\u305a\u3070\u308aJSON\u30c7\u30fc\u30bf\u306e\u30d1\u30fc\u30b9\u3067\u3059\u3002<\/p>\n

V16\u3067\u3001JSON\u95a2\u6570\u304c\u8ffd\u52a0\u3055\u308c\u307e\u3057\u305f\u3002<\/p>\n

\u904e\u53bb\u306e\u30d6\u30ed\u30b0\u3067\u7d39\u4ecb\u3057\u3066\u3044\u307e\u3059\u3002: [FileMaker 16 \u306e\u65b0\u6a5f\u80fd\u3000\u300cJSON\u95a2\u6570\u300d<\/a>]<\/p>\n

 <\/p>\n

\u3057\u304b\u3057\u3001\u3053\u306e\u3068\u304d\u306b\u8ffd\u52a0\u3055\u308c\u305f\u95a2\u6570\u3067\u3001\u30d1\u30fc\u30b9\u3057\u306b\u304f\u3044JSON\u30c7\u30fc\u30bf\u304c\u3042\u308a\u307e\u3059\u3002
\n\u305d\u308c\u306f\u3069\u3093\u306a\u30c7\u30fc\u30bf\u304b\u3068\u3044\u3046\u3068\u3001 \u4e0b\u8a18\u306e\u3088\u3046\u306a\u914d\u5217\u306e\u5404Value\u3092\u30ea\u30b9\u30c8\u306b\u3057\u305f\u3044\u3068\u304d\u3067\u3059\u3002<\/p>\n

 <\/p>\n\n\n\n\n\n
\/\/\u91d1\u878d\u6a5f\u95a2\u30b3\u30fc\u30c9API
\n\/\/https:\/\/bank.teraren.com\/doc<\/th>\n<\/tr>\n<\/thead>\n
[
\n{
\n“code”: “0000”,
\n“kana”: “\u30cb\u30c4\u30dd\u30f3”,
\n“name”: “\u65e5\u672c”,
\n“url”: “https:\/\/bank.teraren.com\/banks\/0000.json”,
\n“branches_url”: “https:\/\/bank.teraren.com\/banks\/0000\/branches.json”
\n},
\n{
\n“code”: “0001”,
\n“kana”: “\u30df\u30ba\u30db”,
\n“name”: “\u307f\u305a\u307b”,
\n“url”: “https:\/\/bank.teraren.com\/banks\/0001.json”,
\n“branches_url”: “https:\/\/bank.teraren.com\/banks\/0001\/branches.json”
\n},
\n{
\n“code”: “0005”,
\n“kana”: “\u30df\u30c4\u30d3\u30b7\u30c8\u30a6\u30ad\u30e8\u30a6UFJ”,
\n“name”: “\u4e09\u83f1\u6771\u4eac\uff35\uff26\uff2a”,
\n“url”: “https:\/\/bank.teraren.com\/banks\/0005.json”,
\n“branches_url”: “https:\/\/bank.teraren.com\/banks\/0005\/branches.json”
\n},
\n{
\n“code”: “0009”,
\n“kana”: “\u30df\u30c4\u30a4\u30b9\u30df\u30c8\u30e2”,
\n“name”: “\u4e09\u4e95\u4f4f\u53cb”,
\n“url”: “https:\/\/bank.teraren.com\/banks\/0009.json”,
\n“branches_url”: “https:\/\/bank.teraren.com\/banks\/0009\/branches.json”
\n},
\n{
\n“code”: “0010”,
\n“kana”: “\u30ea\u30bd\u30ca”,
\n“name”: “\u308a\u305d\u306a”,
\n“url”: “https:\/\/bank.teraren.com\/banks\/0010.json”,
\n“branches_url”: “https:\/\/bank.teraren.com\/banks\/0010\/branches.json”
\n},
\n….
\n]<\/td>\n<\/tr>\n<\/thead>\n<\/table>\n

 <\/p>\n

 <\/p>\n

\u4e0a\u8a18\u306e\u3088\u3046\u306aJSON\u30c7\u30fc\u30bf\u3092\u3001name\u3092\u53d6\u5f97\u3057\u3066\u3001\u305d\u308c\u3092\u30ea\u30b9\u30c8\u306b\u3057\u305f\u3044\u3068\u3044\u3046\u5834\u5408\u3067\u3059\u3002<\/p>\n

 <\/p>\n\n\n\n\n\n
\/\/ \u53d6\u5f97\u3057\u305f\u3044\u7d50\u679c<\/th>\n<\/tr>\n<\/thead>\n
\u65e5\u672c
\n\u307f\u305a\u307b
\n\u4e09\u83f1\u6771\u4eac\uff35\uff26\uff2a
\n\u4e09\u4e95\u4f4f\u53cb
\n\u308a\u305d\u306a
\n\u30fb\u30fb\u30fb<\/td>\n<\/tr>\n<\/thead>\n<\/table>\n

 <\/p>\n

JSON\u95a2\u6570\u3067\u3001\u305d\u308c\u305e\u308c\u3092\u53d6\u3063\u3066\u304f\u308b\u3053\u3068\u306f\u3001\u7c21\u5358\u3067\u3059\u3002
\n\u4f8b\u3048\u3070\u3001<\/p>\n

 <\/p>\n\n\n\n\n\n
\u5f0f<\/th>\n\u7d50\u679c<\/th>\n<\/tr>\n<\/thead>\n
JSONGetElement ( JSON; “[0].name” )<\/td>\n\u65e5\u672c<\/td>\n<\/tr>\n<\/thead>\n<\/table>\n

 <\/p>\n

\u305f\u3060\u3057\u3001\u914d\u5217\u306e\u305d\u308c\u305e\u308c\u306b\u756a\u53f7\u3092\u6307\u5b9a\u3057\u306a\u3044\u3068\u30d1\u30fc\u30b9\u3067\u304d\u307e\u305b\u3093\u3002<\/p>\n

\u3067\u3059\u304b\u3089\u4eca\u307e\u3067\u306f\u3001\u30b9\u30af\u30ea\u30d7\u30c8\u3067\u914d\u5217\u306e\u6570\u5206Loop\u3057\u3066\u3001\u914d\u5217\u306e\u756a\u53f7\u3092\u6307\u5b9a\u3057\u306a\u304c\u3089\u30d1\u30fc\u30b9\u3057\u305f\u5024\u3092\u4e00\u3064\u306e\u6539\u884c\u533a\u5207\u308a\u30c6\u30ad\u30b9\u30c8\u306b\u3059\u308b\u5fc5\u8981\u304c\u3042\u308a\u307e\u3057\u305f\u3002<\/p>\n

\u3053\u308c\u3092\u3001\u300cWhile\u300d\u95a2\u6570\u3092\u4f7f\u7528\u3059\u308c\u3070\u4e00\u767a\u3067\u3001\u53d6\u5f97\u3067\u304d\u307e\u3059\u3002<\/p>\n

 <\/p>\n

 <\/p>\n\n\n\n\n\n
\u5f0f<\/th>\n\u7d50\u679c<\/th>\n<\/tr>\n<\/thead>\n
\/\/ FileMaker\u300cWhile\u300d<\/p>\n

While (
\n[
\n\/\/\u521d\u671f\u5909\u6570
\n~i = 0 ;
\n~result = “”;
\n~json = JSON;
\n~cnt = ValueCount ( JSONListKeys ( ~json ; “” ) )<\/p>\n

] ;
\n\/\/\u6761\u4ef6
\n~i < ~cnt;<\/p>\n

[
\n\/\/\u30ed\u30b8\u30c3\u30af
\n~name = JSONGetElement ( ~json ; “[” & ~i & “]name” );
\n~result = Case ( not IsEmpty ( ~result ) ; ~result & \u00b6 ) & ~name;
\n~i = ~i + 1<\/p>\n

];
\n\/\/\u7d50\u679c
\n~result<\/p>\n

)<\/td>\n

\u65e5\u672c
\n\u307f\u305a\u307b
\n\u4e09\u83f1\u6771\u4eac\uff35\uff26\uff2a
\n\u4e09\u4e95\u4f4f\u53cb
\n\u308a\u305d\u306a<\/td>\n<\/tr>\n<\/thead>\n<\/table>\n

 <\/p>\n

 <\/p>\n

\u4e0a\u8a18\u306e\u91d1\u878d\u6a5f\u95a2\u30b3\u30fc\u30c9API\u3092\u5229\u7528\u3057\u305f\u30b5\u30f3\u30d7\u30eb\u30d5\u30a1\u30a4\u30eb\u3092\u4f5c\u6210\u3057\u3066\u307f\u307e\u3057\u305f\u3002<\/p>\n

\"\"<\/p>\n

 <\/p>\n

\u305f\u3081\u3057\u306b\u3001\u691c\u7d22\u30ad\u30fc\u30ef\u30fc\u30c9\u306b\u3001”\u308a\u305d\u306a”\u3068\u5165\u529b\u3057\u3066\u304b\u3089\u300c\u691c\u7d22\u5b9f\u884c\u300d\u30dc\u30bf\u30f3\u3092\u30af\u30ea\u30c3\u30af\u3057\u3066\u4e0b\u3055\u3044\u3002 \u305d\u3046\u3059\u308b\u3068\u3001\u30d7\u30eb\u30c0\u30a6\u30f3\u30c6\u30ad\u30b9\u30c8\u306e\u3068\u3053\u308d\u306b\u3001”\u308a\u305d\u306a”\u3068”\u57fc\u7389\u308a\u305d\u306a”\u3068\u51fa\u3066\u304d\u307e\u3059\u3002<\/p>\n

\u300cWhile\u300d\u95a2\u6570\u3067\u3001\u8a08\u7b97\u3057\u305f\u7d50\u679c\u3092\u81ea\u52d5\u5165\u529b\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n

\u3053\u306e\u72b6\u614b\u3067\u3001\u300c\u91d1\u878d\u6a5f\u95a2\u300d\u30d5\u30a3\u30fc\u30eb\u30c9\u306b\u30ab\u30fc\u30bd\u30eb\u3092\u5165\u308c\u308b\u3068\u3001\u5024\u4e00\u89a7\u306b\u691c\u7d22\u3055\u308c\u305f\u5024\u304c\u30d7\u30eb\u30c0\u30a6\u30f3\u3055\u308c\u307e\u3059\u3002<\/p>\n

 <\/p>\n

\"\"<\/p>\n

 <\/p>\n

\u30d7\u30eb\u30c0\u30a6\u30f3\u304b\u3089\u3001\u91d1\u878d\u6a5f\u95a2\u540d\u3092\u9078\u629e\u3059\u308b\u3068\u3001\u300c\u91d1\u878d\u6a5f\u95a2\u30b3\u30fc\u30c9\u300d\u30d5\u30a3\u30fc\u30eb\u30c9\u306b\u30b3\u30fc\u30c9\u304c\u81ea\u52d5\u5165\u529b\u3055\u308c\u308b\u3068\u3044\u3046\u30b5\u30f3\u30d7\u30eb\u3067\u3059\u3002
\n\u652f\u5e97\u306b\u3064\u3044\u3066\u306f\u3001\u9078\u629e\u3057\u305f\u91d1\u878d\u6a5f\u95a2\u306e\u652f\u5e97\u304c\u5024\u4e00\u89a7\u306b\u306a\u308b\u3088\u3046\u306b\u3057\u3066\u3044\u307e\u3059\u3002<\/p>\n

 <\/p>\n

\"\"<\/p>\n

 <\/p>\n

\u3053\u306e\u30b5\u30f3\u30d7\u30eb\u306f\u3001\u4e0b\u8a18\u304b\u3089\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u53ef\u80fd\u3067\u3059\u3002<\/p>\n

\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u306f\u3053\u3061\u3089\u304b\u3089\uff081KB\uff09<\/a><\/p>\n

\u3044\u304b\u304c\u3067\u3057\u305f\u3067\u3057\u3087\u3046\u304b\u3002<\/p>\n

\u5177\u4f53\u7684\u30b5\u30f3\u30d7\u30eb\u3092\u78ba\u8a8d\u3059\u308b\u3068 While\u95a2\u6570<\/em><\/strong> \u306e\u4fbf\u5229\u3055\u304c\u5b9f\u611f\u51fa\u6765\u308b\u306e\u3067\u306f\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n

 <\/p>\n

 <\/p>\n","protected":false},"excerpt":{"rendered":"

\u524d\u56de\u306f\u3001\u300cWhile\u300d\u95a2\u6570\u306e\u4f7f\u3044\u65b9\u306e\u57fa\u672c\u3092\u898b\u3066\u307f\u307e\u3057\u305f\u3002   \u524d\u56de\u306e\u300cWhile\u300d\u95a2\u6570\u306e\u30d6\u30ed\u30b0: FileMaker Pro 18 Advanced \u306e\u65b0\u6a5f\u80fd\u3000\u3010\u300cWhile\u300d\u95a2\u6570\u30fb\u300cSetRecursion\u300d […]<\/p>\n","protected":false},"author":6,"featured_media":6878,"comment_status":"closed","ping_status":"closed","sticky":false,"template":"","format":"standard","meta":{"_monsterinsights_skip_tracking":false,"_monsterinsights_sitenote_active":false,"_monsterinsights_sitenote_note":"","_monsterinsights_sitenote_category":0,"footnotes":""},"categories":[395],"tags":[396,412],"class_list":["post-6843","post","type-post","status-publish","format-standard","has-post-thumbnail","hentry","category-filemaker-18","tag-filemaker-18","tag-while"],"aioseo_notices":[],"aioseo_head":"\n\t\t\n\t\n\t\n\t\n\t\n\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t\n\t\t