{"id":95,"date":"2012-07-30T11:44:47","date_gmt":"2012-07-30T02:44:47","guid":{"rendered":"http:\/\/ywc.com\/filemaker\/?p=95"},"modified":"2013-08-22T12:59:21","modified_gmt":"2013-08-22T03:59:21","slug":"executesql%e3%82%92%e4%bd%bf%e3%81%a3%e3%81%a6%e3%81%bf%e3%82%8b%e3%80%80%e3%81%9d%e3%81%ae2%e3%80%80%e3%80%80%ef%bc%88filemaker-12-%e3%81%ae%e9%96%a2%e6%95%b0%ef%bc%89","status":"publish","type":"post","link":"https:\/\/ywc.com\/filemaker\/?p=95","title":{"rendered":"ExecuteSQL\u3092\u4f7f\u3063\u3066\u307f\u308b\u3000\u305d\u306e2\u3000\u3000\uff08FileMaker 12 \u306e\u95a2\u6570\uff09"},"content":{"rendered":"

\u4eca\u56de\u306f\u3001\u30d5\u30a1\u30a4\u30eb\u30e1\u30fc\u30ab\u30fc12(FileMaker 12)\u3067\u8ffd\u52a0\u3055\u308c\u305f\u65b0\u3057\u3044\u95a2\u6570\u3067\u3042\u308bExecuteSQL\u306b\u3064\u3044\u3066\u306e2\u56de\u76ee\u3067\u3059\u3002<\/p>\n

\uff08\u6570\u56de\u306b\u308f\u305f\u3063\u3066ExecuteSQL\u306b\u3064\u3044\u3066\u8a18\u8f09\u3057\u3066\u3044\u304f\u4e88\u5b9a\u3067\u3059\u304c\u3001\u3053\u306e\u30c6\u30fc\u30de\u306b\u3064\u3044\u3066\u306f\u7d041\u30f6\u6708\u304a\u304d\u306e\u66f4\u65b0\u3068\u306a\u308a\u307e\u3059\u3002<\/p>\n

\u6c17\u9577\u306b\u304a\u5f85\u3061\u3044\u305f\u3060\u3051\u308c\u3070\u2026\u3068\u601d\u3044\u307e\u3059\u3002\uff09<\/p>\n

 <\/p>\n

\u524d\u56de<\/a>\u306f\u3001ExecuteSQL\u95a2\u6570\u304c\u3069\u306e\u69d8\u306a\u95a2\u6570\u304b\u306b\u3064\u3044\u3066\u8a18\u8f09\u3057\u307e\u3057\u305f\u3002<\/p>\n

\u4eca\u56de\u306f\u3001SQL\u30af\u30a8\u30ea\u30fc\u3067\u4f7f\u7528\u3067\u304d\u308b\u3082\u306e\u306b\u3064\u3044\u3066\u8a18\u8f09\u3057\u3066\u3044\u304d\u307e\u3059\u3002<\/p>\n

\u8272\u3005\u3068\u8abf\u3079\u3066\u307f\u305f\u3068\u3053\u308d\u3001\u57fa\u672c\u7684\u306bODBC\/JDBC\u3067FileMaker\u306b\u5bfe\u3057\u3066\u4f7f\u3048\u308b\u7269\u304c\u307b\u307c\u4f7f\u3048\u308b\u3088\u3046\u3067\u3059\u3002<\/p>\n

\u300eFileMaker 12 ODBC \u3068 JDBC \u30ac\u30a4\u30c9\u300f\u306e\u300c\u7b2c7\u7ae0 \u30b5\u30dd\u30fc\u30c8\u3055\u308c\u3066\u3044\u308b\u6a19\u6e96\u300d\u306b\u8a18\u8f09\u3055\u308c\u3066\u3044\u308b\u7269\u3092\u691c\u8a3c\u3057\u3066\u307f\u307e\u3057\u305f\u306e\u3067\u3001\u3054\u53c2\u8003\u306b\u3057\u3066\u3044\u305f\u3060\u3051\u308c\u3070\u3068\u601d\u3044\u307e\u3059\u3002<\/p>\n

\uff08\u300eFileMaker 12 ODBC \u3068 JDBC \u30ac\u30a4\u30c9\u300f\u306f\u3001\u4ee5\u4e0b\u306eURL\u3088\u308a\u30c0\u30a6\u30f3\u30ed\u30fc\u30c9\u3067\u304d\u307e\u3059\u3002\uff09<\/p>\n

\uff08http:\/\/www.filemaker.co.jp\/support\/product\/documentation.html<\/a>\uff09<\/p>\n

 <\/p>\n

SQL \u30b9\u30c6\u30fc\u30c8\u30e1\u30f3\u30c8<\/p>\n\n\n\n\n\n\n\n\n\n\n\n
\n

\u9805\u76ee<\/p>\n<\/td>\n

\n

\u4f7f\u7528\u53ef\u5426<\/p>\n<\/td>\n

\n

\u5099\u8003<\/p>\n<\/td>\n<\/tr>\n

\n

SELECT<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

\n

DISTIONCT\u3001AS\u3082\u25cb<\/p>\n<\/td>\n<\/tr>\n

\n

DELETE<\/p>\n<\/td>\n

\n

\u00d7<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

INSERT<\/p>\n<\/td>\n

\n

\u00d7<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

UPDATE<\/p>\n<\/td>\n

\n

\u00d7<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

CREATE TABLE<\/p>\n<\/td>\n

\n

\u00d7<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

ALTER TABLE<\/p>\n<\/td>\n

\n

\u00d7<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

CREATE INDEX<\/p>\n<\/td>\n

\n

\u00d7<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

DROP INDEX<\/p>\n<\/td>\n

\n

\u00d7<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

SQL \u53e5<\/p>\n\n\n\n\n\n\n\n\n\n\n
\n

\u9805\u76ee<\/p>\n<\/td>\n

\n

\u4f7f\u7528\u53ef\u5426<\/p>\n<\/td>\n

\n

\u5099\u8003<\/p>\n<\/td>\n<\/tr>\n

\n

FROM<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

WHERE<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

GROUP BY<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

HAVING<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

UNION<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

ORDER BY<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

\n

DESC\u3001ASC\u3082\u25cb\u3000\u6570\u5024\u6307\u5b9a\u3082\u25cb<\/p>\n<\/td>\n<\/tr>\n

\n

FOR UPDATE<\/p>\n<\/td>\n

\n

\u00d7<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

FROM \u53e5<\/p>\n\n\n\n\n\n\n\n
\n

\u9805\u76ee<\/p>\n<\/td>\n

\n

\u4f7f\u7528\u53ef\u5426<\/p>\n<\/td>\n

\n

\u5099\u8003<\/p>\n<\/td>\n<\/tr>\n

\n

INNER JOIN<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

LEFT JOIN<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

\n

LEFT OUTER JOIN\u3067\u3082\u53ef<\/p>\n<\/td>\n<\/tr>\n

\n

RIGHT JOIN<\/p>\n<\/td>\n

\n

\u00d7<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

FULL OUTER JOIN<\/p>\n<\/td>\n

\n

\u00d7<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

CAST\u95a2\u6570\u3001GetAs\u95a2\u6570<\/p>\n\n\n\n\n\n
\n

\u9805\u76ee<\/p>\n<\/td>\n

\n

\u4f7f\u7528\u53ef\u5426<\/p>\n<\/td>\n

\n

\u5099\u8003<\/p>\n<\/td>\n<\/tr>\n

\n

CAST<\/p>\n<\/td>\n

\n

\u25b3<\/p>\n<\/td>\n

\n

\u4e00\u90e8\u306e\u307f<\/p>\n<\/td>\n<\/tr>\n

\n

GetAs<\/p>\n<\/td>\n

\n

\u25b3<\/p>\n<\/td>\n

\n

\u30d5\u30a1\u30a4\u30eb\u540d\u3092\u53d6\u5f97<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

SQL \u7d71\u8a08\u95a2\u6570<\/p>\n\n\n\n\n\n\n\n\n
\n

\u9805\u76ee<\/p>\n<\/td>\n

\n

\u4f7f\u7528\u53ef\u5426<\/p>\n<\/td>\n

\n

\u5099\u8003<\/p>\n<\/td>\n<\/tr>\n

\n

SUM<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

AVG<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

COUNT<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

MAX<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

MIN<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

\u5b9a\u6570<\/p>\n\n\n\n\n\n\n\n\n
\n

\u9805\u76ee<\/p>\n<\/td>\n

\n

\u4f7f\u7528\u53ef\u5426<\/p>\n<\/td>\n

\n

\u5099\u8003<\/p>\n<\/td>\n<\/tr>\n

\n

\u30c6\u30ad\u30b9\u30c8<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

\u6570\u5b57<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

\u65e5\u4ed8<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

\n

DATE \u20192012-06-05\u2032 \u5f62\u5f0f\u306e\u307f<\/p>\n<\/td>\n<\/tr>\n

\n

\u6642\u523b<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

\n

TIME \u201914:35:10\u2032 \u5f62\u5f0f\u306e\u307f<\/p>\n<\/td>\n<\/tr>\n

\n

\u30bf\u30a4\u30e0\u30b9\u30bf\u30f3\u30d7<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

\n

TIMESTAMP \u20192012-06-05 14:35:10\u2032\u3000\u5f62\u5f0f\u306e\u307f<\/p>\n<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

\u6307\u6570\u307e\u305f\u306f\u79d1\u5b66\u8868\u8a18<\/p>\n\n\n\n\n
\n

\u9805\u76ee<\/p>\n<\/td>\n

\n

\u4f7f\u7528\u53ef\u5426<\/p>\n<\/td>\n

\n

\u5099\u8003<\/p>\n<\/td>\n<\/tr>\n

\n

nE\u00b1a<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

\u6570\u5024\u6f14\u7b97\u5b50<\/p>\n\n\n\n\n\n\n\n\n\n
\n

\u9805\u76ee<\/p>\n<\/td>\n

\n

\u4f7f\u7528\u53ef\u5426<\/p>\n<\/td>\n

\n

\u5099\u8003<\/p>\n<\/td>\n<\/tr>\n

\n

+<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

–<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

*<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

\/<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

^<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

**<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

\u6587\u5b57\u6f14\u7b97\u5b50<\/p>\n\n\n\n\n\n
\n

\u9805\u76ee<\/p>\n<\/td>\n

\n

\u4f7f\u7528\u53ef\u5426<\/p>\n<\/td>\n

\n

\u5099\u8003<\/p>\n<\/td>\n<\/tr>\n

\n

+<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

–<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

\u65e5\u4ed8\u6f14\u7b97\u5b50<\/p>\n\n\n\n\n\n
\n

\u9805\u76ee<\/p>\n<\/td>\n

\n

\u4f7f\u7528\u53ef\u5426<\/p>\n<\/td>\n

\n

\u5099\u8003<\/p>\n<\/td>\n<\/tr>\n

\n

+<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

–<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

\u30ea\u30ec\u30fc\u30b7\u30e7\u30ca\u30eb\u6f14\u7b97\u5b50<\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
\n

\u9805\u76ee<\/p>\n<\/td>\n

\n

\u4f7f\u7528\u53ef\u5426<\/p>\n<\/td>\n

\n

\u5099\u8003<\/p>\n<\/td>\n<\/tr>\n

\n

=<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

<><\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

><\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

>=<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

<<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

<=<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

LIKE<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

NOT LIKE<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

IS NULL<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

IS NOT NULL<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

BETWEEN<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

IN<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

NOT IN<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

EXISTS<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

ANY<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n
\n

ALL<\/p>\n<\/td>\n

\n

\u25cb<\/p>\n<\/td>\n

<\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

 <\/p>\n

\u4eca\u56de\u306f\u3053\u3053\u307e\u3067\u3067\u3059\u3002\u6b8b\u308a\u306e\u95a2\u6570\u306b\u3064\u3044\u3066\u306f\u3001\u6b21\u56de\u8a18\u8f09\u4e88\u5b9a\u3067\u3059\u3002<\/p>\n","protected":false},"excerpt":{"rendered":"

\u4eca\u56de\u306f\u3001\u30d5\u30a1\u30a4\u30eb\u30e1\u30fc\u30ab\u30fc12(FileMaker 12)\u3067\u8ffd\u52a0\u3055\u308c\u305f\u65b0\u3057\u3044\u95a2\u6570\u3067\u3042\u308bExecuteSQL\u306b\u3064\u3044\u3066\u306e2\u56de\u76ee\u3067\u3059\u3002 \uff08\u6570\u56de\u306b\u308f\u305f\u3063\u3066ExecuteSQL\u306b\u3064\u3044\u3066\u8a18\u8f09\u3057\u3066\u3044\u304f\u4e88\u5b9a\u3067\u3059\u304c\u3001\u3053\u306e\u30c6\u30fc\u30de\u306b\u3064\u3044\u3066\u306f\u7d041 […]<\/p>\n","protected":false},"author":2,"featured_media":0,"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":[10],"tags":[],"class_list":["post-95","post","type-post","status-publish","format-standard","hentry","category-tips"],"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