ããŒã¿
ããŒã¿ ã¿ãã§ã¯ãéžæäžã®ã³ã³ãããŒã«ã«äœ¿çšãããããŒã¿ãœãŒã¹ãæå®ããŸãã

ããŒã¿ããŒã¹ã«ãªã³ã¯ããŠãããã©ãŒã ã®å Žåããã©ãŒã 屿§ã§ãä»éããããŒã¿ããŒã¹ãæå®ããŸãããã®ããã®æ©èœã¯ãããŒã¿ ã¿ãã«ãããŸãã
ããŒã¿ ã¿ãã§èšå®ããå 容ã¯ãã³ã³ãããŒã«ã®çš®é¡ã«ããç°ãªããŸããããã«è¡šç€ºããããªãã·ã§ã³ã¯ãçŸåšã®ã³ã³ãããŒã«ãšã³ã³ããã¹ãã§äœ¿çšå¯èœãªãã®ã ãã§ãã䜿çšå¯èœãªãã£ãŒã«ãã«ã¯äžèšã®ãã®ããããŸãã
ãœãŒã¹ã»ã«ç¯å²
ãªã¹ãããã¯ã¹ãŸãã¯ã³ã³ãããã¯ã¹çšã®é ç®ãå ¥ã£ãŠããã衚èšç®ããã¥ã¡ã³ãã«ããã»ã«ç¯å²ããå ¥åããŸãã è€æ°åã®ç¯å²ãå ¥åããå Žåãã³ã³ãããŒã«ãåããããã«ã¯ã巊端ã®åã®å 容ã ãã䜿çšãããŸãã
ããŒã¿ãã£ãŒã«ã
ããŒã¿ããŒã¹ãã©ãŒã ã䜿çšããããšã§ãããŒã¿ãã£ãŒã«ããšã³ã³ãããŒã«ããªã³ã¯ãããããšãã§ããŸãã
ããã§ã¯ãèæ ®ãã¹ãã±ãŒã¹ãããã€ããããŸãã
-
æåã®ã±ãŒã¹:ãã©ãŒã å ã«ããŒãã«ãã²ãšã€ã ãååšããå Žåã
ããŒã¿ãã£ãŒã«ã屿§ã«ã¯ããã£ãŒã«ãå 容ã衚瀺ããããŒã¿ãœãŒã¹ããŒãã«ã®ãã£ãŒã«ããæå®ããŸãã
-
第 2 ã®ã±ãŒã¹:SQL ã¯ãšãªãŒã«ãã£ãŠäœæããããµããã©ãŒã ã«ã³ã³ãããŒã«ãå±ããŸãã
ããŒã¿ãã£ãŒã«ã屿§ã«ã¯ããã£ãŒã«ãå 容ã衚瀺ãã SQL ã¹ããŒãã¡ã³ãã®ãã£ãŒã«ããæå®ããŸãã
-
第 3 ã®ã±ãŒã¹:ã³ã³ãããã¯ã¹
ã³ã³ãããã¯ã¹ã®å ŽåãããŒã¿ãã£ãŒã«ã ã§ããŠãŒã¶ãŒãå ¥åãããã¯éžæããå€ãä¿åããçŸåšã®ãã©ãŒã ããŒãã«ã®ãã£ãŒã«ããå ¥åããŸãã(ãªã¹ãã®å 容 ã§å ¥åãã SQLã¹ããŒãã¡ã³ãã«ããããã®ã³ã³ãããã¯ã¹ã«è¡šç€ºãããå€ãæå®ããŸãã)
-
第 4 ã®ã±ãŒã¹:ãªã¹ãããã¯ã¹
ããŒã¿ãœãŒã¹ããŒãã«ã衚瀺ããããŒã¿ãæã€ã®ã§ã¯ãªããå ±éããŒã¿ãã£ãŒã«ãçµç±ã§ããŒã¿ãœãŒã¹ããŒãã«ã«ãªã³ã¯ãããããŒãã«ã§ããå Žåã
ããšãã°ãçŸåšã®ããŒã¿ãœãŒã¹ããŒãã«ã«ãªã³ã¯ããããŒãã«ããããŒã¿ãèªã¿èŸŒãã§ãããããªã¹ãããã¯ã¹ã«è¡šç€ºãããå ŽåãããŒã¿ãã£ãŒã«ã ã«ã¯ããã®ãªã¹ãããã¯ã¹ã«åç §ãããããŒã¿ãœãŒã¹ããŒãã«ã®ãã£ãŒã«ããæå®ããŸãããããã¯ããã©ãŒã äžã§ã®ããŒã¿è¡šç€ºãå¶åŸ¡ãããããŒã¿ããŒã¹ãã£ãŒã«ããæå®ããŸãããã®å Žåã¯ã2 ã€ã®ããŒãã«ãå ±éã®ããŒã¿ãã£ãŒã«ãã§ãªã³ã¯ã§ãããã®ãšããŠã仿¹ã®ããŒãã«ãžã®ãªã³ã¯ãããã®ããŒã¿ãã£ãŒã«ãã§äžç¶ãããŸããéåžžããããããªã³ã¯çšã®ããŒã¿ãã£ãŒã«ãã«ã¯ãäžæçã«æ±ºãŸãèå¥çªå·ãåããããŒã¿ãã£ãŒã«ãã䜿çšããã®ãæ®éã§ãããã©ãŒã ã«è¡šç€ºããããŒã¿ãã£ãŒã«ãã¯ããªã¹ãã®å 容 ã® SQL ã¹ããŒãã¡ã³ãã§æå®ããŸãã
ãªã¹ãããã¯ã¹ããåç §ã«ãã£ãŠåäœãããŸããSQLã¹ããŒãã¡ã³ã(第ïŒäŸ)ãä»ããŠãªã³ã¯ããŠããããŒãã«ã䜿ã£ãŠããããã¯å€ã®ãªã¹ããä»ããŠãªã¹ãããã¯ã¹ãåäœãããããšãã§ããŸãã
ãªã³ã¯ããŠããããŒãã«(SQLã¹ããŒãã¡ã³ã)ã«ããåç §
ãªã¹ãããã¯ã¹ã«è¡šç€ºãããããŒã¿ãããã©ãŒã ã§å©çšããããŒãã«ã«å ±éããŒã¿ãã£ãŒã«ãã§ãªã³ã¯ãããããŒã¿ããŒã¹ããŒãã«ããåãåºãå Žåããã©ãŒã ããŒãã«ã®ãªã³ã¯ãã£ãŒã«ãã ããŒã¿ãã£ãŒã«ã ã§æå®ããŸãã
ãªã¹ãã®å 容ã®çš®é¡ ã§ãsqlãããsql [Native]ããéžæããå Žåããã®ãªã³ã¯ã¯ ãªã¹ãã®å 容 ãã£ãŒã«ãã«è¡šç€ºããã SQL ã¹ããŒãã¡ã³ãã® Select å¥ã§åŠçãããŸããããšãã°ããã©ãŒã ã³ã³ãããŒã«ã«ãªã³ã¯ãããOrderãããŒãã«ããããããŒã¿ããŒã¹äžã§ã¯ãã®ãOrderãããŒãã«ã«å¯ŸããŠãCustomersãããŒãã«ããªã³ã¯ããŠãããšããç¶æ³ãæ³å®ããŸãããã®å Žåã® SQL ã¹ããŒãã¡ã³ãã¯äžèšã®ããã«èšè¿°ã§ããŸãã
SELECT CustomerName, CustomorNo FROM Customers,
ããã§ãCustomerNameãã¯ãªã³ã¯å ã®ãCustomersãããŒãã«äžã®ããŒã¿ãã£ãŒã«ãã§ããããCustomerNoãããCustomersãããŒãã«äžã®ããŒã¿ãã£ãŒã«ãã§ããããã¡ã㯠ããŒã¿ãã£ãŒã«ã ã«ãã©ãŒã ããŒãã«ãšããŠæå®ãããOrdersãããŒãã«äžã®ãã£ãŒã«ãã«ãªã³ã¯ããŠãããã®ã§ãã
å€ã®ãªã¹ããä»ããåç §
ãªã¹ãããã¯ã¹ã®å Žåãå€ã®ãªã¹ãã䜿ãããšãã§ããŸããããã¯ãåç §å€ãå®çŸ©ãããªã¹ãã§ããããã«ããããã©ãŒã å ã®ã³ã³ãããŒã«ã«çŽæ¥ãããŒã¿ããŒã¹ãã£ãŒã«ãã®å 容ã衚瀺ãããã®ã§ã¯ãªããå€ã®ãªã¹ãã«å²ãåœãŠãããå€ãä»ããŠè¡šç€ºãããŸãã
å€ãªã¹ãã®åç §å€ãæäœããããšã§ããã©ãŒã ã® ããŒã¿ãã£ãŒã«ã ã«æå®ããããŒã¿ãã£ãŒã«ãã®å 容ã衚瀺ããããšãªããå²ãåœãŠãå€ã衚瀺ãããããã«ãªããŸããããŒã¿ ã¿ãã® ãªã¹ãå 容ã®çš®é¡ ã§ãå€ãªã¹ãããéžæãããã©ãŒã äžã®è¡šç€ºãªã¹ãã®é ç®ãžã®åç §å€ãããªã¹ãã®é ç® (å šè¬ ã¿ãã§å ¥å) ã«æå®ãããšããã®åç §å€ãšæå®ããŒã¿ãã£ãŒã«ãã®å 容ãšãæ¯èŒãããŸããåç §å€ã«äžèŽããããŒã¿ãã£ãŒã«ãã®å 容ãååšãããšã察å¿ãããªã¹ãã®é ç®ããã©ãŒã ã«è¡šç€ºãããŸãã
ãã£ã«ã¿ãŒåè£
ãã©ãŒã ã®ãã¶ã€ã³ãããéã«ã¯ã察å¿ãã 屿§ ãã€ã¢ãã°ã® ããŒã¿ ã¿ãã«ããåããã¹ãããã¯ã¹ã®ããã£ã«ã¿ãŒåè£ã屿§ãæå®ã§ããŸãããã£ã«ã¿ãŒã¢ãŒãã§ã®ãã以éã®æ€çŽ¢å®è¡æã«ã¯ããããã®ãã£ãŒã«ãã«ãããã¹ãŠã®æ å ±ãéžæåè£ãšãªããŸãã ãã®ããã«ããŠããããšã§ããªãŒãã³ã³ããªãŒãæ©èœã䜿ã£ãŠãã£ãŒã«ãã®å 容ãç°¡åã«éžæã§ããŸãããã ãããã®æ©èœã¯ãç¹ã«å€§èŠæš¡ãªããŒã¿ããŒã¹ã§ã¯éåžžã«å€§éã®ã¡ã¢ãªã¹ããŒã¹ãšæéãå¿ èŠãšããããã䜿çšããå Žåã«ã¯ååæ³šæããå¿ èŠããããŸãã
ãªã¹ãã®å 容
ããŒã¿ããŒã¹ãã©ãŒã ã§ããã©ãŒã èŠçŽ ã®ãªã¹ãã«è¡šç€ºããããŒã¿ãœãŒã¹ãæå®ããŸãããã®ãã£ãŒã«ãã¯ãããŒã¿ããŒã¹æ¥ç¶ãªãã«ãããã¥ã¡ã³ãã«å€ãªã¹ããæå®ããããã«äœ¿çšããããšãã§ããŸãã
ããŒã¿ããŒã¹ãã©ãŒã ã®å Žåããªã¹ãããã¯ã¹ããã³ã³ã³ãããã¯ã¹ã®è¡šç€ºé ç®ã¯ãããŒã¿ãœãŒã¹ã«ããæ±ºãŸããŸããéžæããçš®é¡ã«å¿ããŠãããŒã¿ããŒã¹äžã«ããã€ãã®ãªããžã§ã¯ããããå Žåããªã¹ãã®å 容 ã«ã¯æå®å¯èœãªè€æ°ã®ããŒã¿ãœãŒã¹ã衚瀺ãããŸãããã«ã¯ããªã¹ãã®å 容ã®çš®é¡ ã§éžæããçš®é¡ã«è©²åœããããã¹ãŠã®ããŒã¿ããŒã¹ãªããžã§ã¯ããäžèŠ§è¡šç€ºãããŸãããªã¹ãã®å 容ã®çš®é¡ãšããŠãå€ãªã¹ãããéžæããå Žåã¯ãããŒã¿ããŒã¹ãã©ãŒã ãžã®åç §å€ã䜿çšã§ããŸãããŸãã³ã³ãããŒã«ã®è¡šç€ºå 容ã SQL ã³ãã³ãã§å¶åŸ¡ããå Žåã¯ãããã«ã¯ SQL ã¹ããŒãã¡ã³ããå ¥åããŸãã
SQLã¹ããŒãã¡ã³ãã®äŸ
ãªã¹ãããã¯ã¹ã®å ŽåãSQL ã¹ããŒãã¡ã³ãã¯æ¬¡ã®åœ¢åŒã«ãªããŸãã
SELECT feld1, feld2 FROM tabelle,
ããã§ããtabelleãã¯ãã³ã³ãããŒã«ã®ãªã¹ãã«è¡šç€ºãããããŒã¿ã®å ¥ã£ãããŒãã«ã®ããšã§ã (ãªã¹ãããŒãã«)ããfeld1ãã¯ããã©ãŒã ã®è¡šç€ºé ç®ãæå®ããããŒã¿ãã£ãŒã«ãã§ããã®å 容ããªã¹ãããã¯ã¹ã«è¡šç€ºãããŸãããªã³ã¯ãããã£ãŒã«ã ã§ =ïŒãéžæããå Žåã«ã¯ããfeld2ãã¯ãããŒã¿ãã£ãŒã«ã ã§å ¥åãããã£ãŒã«ããä»ããŠããã©ãŒã ããŒãã«(å€ã®ããŒãã«)ãšãªã³ã¯ãããªã¹ãããŒãã«ã®ãã£ãŒã«ãã§ãã
ã³ã³ãããã¯ã¹ã®å ŽåãSQL ã¹ããŒãã¡ã³ãã¯æ¬¡ã®åœ¢åŒã«ãªããŸãã
SELECT DISTINCT feld FROM tabelle,
ããã§ã®ãfieldãã®æå³ã¯ãã³ã³ãããã¯ã¹ã®ãªã¹ãã«è¡šç€ºããããªã¹ãããŒãã«ãtableãã«ããããŒã¿ãã£ãŒã«ãã® 1 ã€ã瀺ããŸãã
HTMLããã¥ã¡ã³ãã®å Žåã®å€ã®ãªã¹ã
HTML ãã©ãŒã ã®å Žåã¯ããªã¹ãã®å 容 ã«å€ãªã¹ããå ¥åã§ããŸãããªã¹ãã®å 容ã®çš®é¡ ã§ãå€ãªã¹ãããéžæããŸããããã«å ¥åããå€ã¯ããã©ãŒã äžã«è¡šç€ºãããã®ã§ã¯ãªãã衚瀺é ç®ãžå€ãæå®ããããã«äœ¿çšããŸãããªã¹ãã®å 容 ã«æå®ããé ç®ã¯ãHTML ã¿ã°ã® <OPTION VALUE=...> ã«çžåœãããã®ã§ãã
ãªã¹ãããã¯ã¹ãã³ã³ãããã¯ã¹ã®éžæé ç®ãããŒã¿è»¢éããéã«ã¯ããã©ãŒã ã«è¡šç€ºãããå€ã®ãªã¹ãã§ å šè¬ ã¿ãã® ãªã¹ãã®é ç® ã«å ¥åããããã®ãšãããŒã¿ ã¿ãã® ãªã¹ãã®å 容 ã«å ¥åãããå€ãªã¹ãã®äž¡æ¹ã察象ãšãããŸãããããŠãå€ãªã¹ã (<OPTION VALUE=...>) ã®éžæäœçœ®ã«ç©ºçœã§ãªãããã¹ããããã°ããããéä¿¡ãããŸãããã以å€ã®å Žåã¯ã(<OPTION>) ã³ã³ãããŒã«ã®è¡šç€ºããã¹ããéä¿¡ãããŸãã
å€ãªã¹ãã«ç©ºçœã®æååãæå®ããã«ã¯ããªã¹ãã®å 容 ã®è©²åœç®æã«ã$$$empty$$$ããšå ¥åããŸã (倧æå/å°æåã«æ³šæããŸã)ããã®æåå㯠LibreOffice ã«ããç©ºçœæååãšè§£éããããªã¹ãé ç®ã®äžã«ç»é²ãããŸãã
HTMLãJavaScriptã LibreOffice ãã£ãŒã«ã ãªã¹ãã®å 容 ã®éã®é¢ä¿ããªã¹ãããã¯ã¹åãListBox1ãã䜿ã£ãŠã以äžã®è¡šã«ç€ºããŸãããã®å Žåã®ãItemãã¯ããã©ãŒã ã«è¡šç€ºãããŠãããªã¹ãé ç®ã§ãã
HTMLã¿ã° |
JavaScript |
ã³ã³ãããŒã«ã®å€ã®ãªã¹ãã®é ç®(ãªã¹ãã®å 容) |
転éãããã®ã¯... |
<OPTION>Item |
äžå¯èœ |
"" |
...衚瀺ãããŠãããªã¹ãé ç®(ãListBox1=Itemã)ã |
<OPTION VALUE="Wert">Item |
ListBox1.options[0].value="Wert" |
ãå€ã |
...ãªã¹ãé ç®ã«å²ãåœãŠãããŠããå€(ãListBox1=Wertã)ã |
<OPTION VALUE="Wert">Item |
ListBox1.options[0].value="" |
ã$$$empty$$$ã |
...ã¹ããŒã¹(ãListBox1=ã)ã |
ãªã¹ãã®å 容ã®çš®é¡
ãªã¹ãããã¯ã¹ããã³ã³ã³ãããã¯ã¹ã®ãªã¹ãã«è¡šç€ºããããŒã¿ãæå®ããŸãã
ãå€ãªã¹ãããªãã·ã§ã³ãéžæãããšãå šè¬ ã¿ã ã® ãªã¹ãã®é ç® ãã£ãŒã«ãã«å ¥åãããã¹ãŠã®é ç®ããã³ã³ãããŒã«ã«è¡šç€ºãããŸããããŒã¿ããŒã¹ãã©ãŒã ã«é¢ããŠã¯ãåç §å€ã䜿çšã§ããŸã (詳现㯠å€ã®ãªã¹ããä»ããåç § ã®ç¯ãåç §ããŠãã ãã)ã
ã³ã³ãããŒã«ã®å 容ãããŒã¿ããŒã¹ããèªã¿èŸŒãå Žåãä»ã®ãªãã·ã§ã³ã§ããŒã¿ãœãŒã¹ã®çš®é¡ãæå®ã§ããŸããããšãã°ããã§ã¯ãããŒãã«ãšãããã¯ãšãªãŒãšããããéžæã§ããŸãã
ãªã³ã¯ãããã»ã«
衚èšç®ããã¥ã¡ã³ãã«ãããªã³ã¯ãããã»ã«ã«å¯Ÿããåç §ãæå®ããŸããã³ã³ãããŒã«ã®æå¹ç¡å¹ã®ç¶æ ãå 容ããã»ã«å 容ã«ãªã³ã¯ãããŸãã äžèšã®è¡šã«ãã³ã³ãããŒã«ããã³åã³ã³ãããŒã«ã«å¯Ÿå¿ãããªã³ã¯åã瀺ããŸãã
ãªã³ã¯ãããã»ã«ã®ãããã§ãã¯ããã¯ã¹
ã¢ã¯ã·ã§ã³ |
çµæ |
ãã§ãã¯ããã¯ã¹ãéžæ |
ãªã³ã¯ãããã»ã«ã« TRUE ãå ¥å |
ãã§ãã¯ããã¯ã¹ããªãã«ããŸãã |
ãªã³ã¯ãããã»ã«ã« FALSE ãå ¥å |
3 çš®é¡ã®æ¡ä»¶ä»ããã§ãã¯ããã¯ã¹ããäžç¢ºå®ãç¶æ ã«èšå® |
ãªã³ã¯ãããã»ã«ã« #NV ãå ¥å |
æ°å€ãŸãã¯ãªã³ã¯ãããã»ã«ã«æ°å€ãæ»ãæ°åŒãå ¥å |
å
¥åãããå€ããTRUE ãŸã㯠0 以å€ã®å Žåããã§ãã¯ããã¯ã¹ã¯ãªã³ã«ãªããŸãã |
ãªã³ã¯ãããã»ã«ãã¯ãªã¢ããããããã¹ããå ¥åããããããã¹ããŸãã¯ãšã©ãŒãæ»ãæ°åŒãå ¥å |
ãã§ãã¯ããã¯ã¹ã 3 çš®é¡ã®æ¡ä»¶ä»ããã§ãã¯ããã¯ã¹ã®å Žåã«ã¯ããäžç¢ºå®ãç¶æ ã«èšå®ãããŸããäžèšä»¥å€ã®ãã§ãã¯ããã¯ã¹ã®å Žåã«ã¯ããªãã«ãªããŸãã |
ããã¯ã¹ãéžæããŸãããåç §å€ãããã¯ã¹ã«ããã¹ããå ¥ããŸãã |
ãåç §å€ãããã¯ã¹ããã»ã«ã«ããã¹ããã³ããŒãããŸãã |
ããã¯ã¹ãéžæè§£é€ããŸãããåç §å€ãããã¯ã¹ã«ããã¹ããå ¥ããŸãã |
ç©ºã®æååãã»ã«ã«ã³ããŒãããŸãã |
ãåç §å€ãããã¯ã¹ã«ããã¹ããå ¥ããŸããã»ã«ã«åãããã¹ããå ¥åããŸãã |
ãã§ãã¯ããã¯ã¹ããªã³ã§ãã |
ãåç §å€ãããã¯ã¹ã«ããã¹ããå ¥ããŸããã»ã«ã«å¥ã®ããã¹ããå ¥åããŸãã |
ãã§ãã¯ããã¯ã¹ããªãã§ãã |
ãªã³ã¯ãããã»ã«ã®ãããªãã·ã§ã³ãã¿ã³ (ã©ãžãªãã¿ã³)
ã¢ã¯ã·ã§ã³ |
çµæ |
ãªãã·ã§ã³ãã¿ã³ãéžæããŸãã |
ãªã³ã¯ãããã»ã«ã« TRUE ãå ¥å |
å¥ã®ãªãã·ã§ã³ãã¿ã³ãéžæãããšãªãã·ã§ã³ãã¿ã³ãéžæè§£é€ |
ãªã³ã¯ãããã»ã«ã« FALSE ãå ¥å |
æ°å€ãŸãã¯ãªã³ã¯ãããã»ã«ã«æ°å€ãæ»ãæ°åŒãå ¥å |
å
¥åãããå€ããTRUE ãŸã㯠0 以å€ã®å Žåããªãã·ã§ã³ãã¿ã³ã¯ãªã³ã«ãªããŸãã |
ãªã³ã¯ãããã»ã«ãã¯ãªã¢ããããããã¹ããå ¥åããããããã¹ããŸãã¯ãšã©ãŒãæ»ãæ°åŒãå ¥å |
ãªãã·ã§ã³ãã¿ã³ã®éžæãè§£é€ |
ãªãã·ã§ã³ãã¿ã³ãã¯ãªãã¯ããŸãããåç §å€ãããã¯ã¹ã«ããã¹ããå ¥ããŸãã |
ãåç §å€ãããã¯ã¹ããã»ã«ã«ããã¹ããã³ããŒãããŸãã |
åãã°ã«ãŒãã®å¥ã®ãªãã·ã§ã³ãã¿ã³ãã¯ãªãã¯ããŸãããåç §å€ãããã¯ã¹ã«ããã¹ããå ¥ããŸãã |
ç©ºã®æååãã»ã«ã«ã³ããŒãããŸãã |
ãåç §å€ãããã¯ã¹ã«ããã¹ããå ¥ããŸããã»ã«ã«åãããã¹ããå ¥åããŸãã |
ãªãã·ã§ã³ãã¿ã³ããªã³ã§ãã |
ãåç §å€ãããã¯ã¹ã«ããã¹ããå ¥ããŸããã»ã«ã«å¥ã®ããã¹ããå ¥åããŸãã |
ãªãã·ã§ã³ãã¿ã³ãã¯ãªã¢ãããŸãã |
ãªã³ã¯ãããã»ã«ã®ããããã¹ãããã¯ã¹
ã¢ã¯ã·ã§ã³ |
çµæ |
ããã¹ãããã¯ã¹ã«ããã¹ããå ¥å |
ããã¹ãããªã³ã¯ãããã»ã«ã«ã³ã㌠|
ããã¹ãããã¯ã¹ãã¯ãªã¢ãã |
ãªã³ã¯ãããã»ã«ãã¯ãªã¢ |
ãªã³ã¯ãããã»ã«ã«ããã¹ããŸãã¯æ°å€ãå ¥å |
ããã¹ããŸãã¯æ°å€ããéžæããããã¹ãããã¯ã¹ã«ã³ã㌠|
ãªã³ã¯ãããã»ã«ã«æ°åŒãå ¥å |
æ°åŒã®çµæããããã¹ãããã¯ã¹ã«ã³ã㌠|
ãªã³ã¯ãããã»ã«ãã¯ãªã¢ |
ããã¹ãããã¯ã¹ãã¯ãªã¢ |
ãªã³ã¯ãããã»ã«ã®ããæ°å€ãã£ãŒã«ãããã³æžåŒä»ããã£ãŒã«ã
ã¢ã¯ã·ã§ã³ |
çµæ |
ãã£ãŒã«ãã«æ°å€ãå ¥å |
æ°å€ããªã³ã¯ãããã»ã«ã«ã³ã㌠|
ãã£ãŒã«ããã¯ãªã¢ |
ãªã³ã¯ãããã»ã«ã« 0 ãèšå® |
æ°å€ãŸãã¯ãªã³ã¯ãããã»ã«ã«æ°å€ãæ»ãæ°åŒãå ¥å |
ãã£ãŒã«ãã«æ°å€ãã³ã㌠|
ãªã³ã¯ãããã»ã«ãã¯ãªã¢ããããããã¹ããå ¥åããããããã¹ããŸãã¯ãšã©ãŒãæ»ãæ°åŒãå ¥å |
ãã£ãŒã«ãã« 0 ãèšå® |
ãªã³ã¯ãããã»ã«ã®ãããªã¹ãããã¯ã¹
ãªã¹ãããã¯ã¹ã§ã¯ã2 çš®é¡ã®ãªã³ã¯ã¢ãŒãããµããŒããããŠããŸããããªã³ã¯ãããã»ã«ã®å 容ãããããã£ãåç §ããŠãã ããã
-
ããªã³ã¯ãããå 容ãã§ã¯ããªã¹ãããã¯ã¹ã®éžæããé ç®ã®å 容ããã»ã«ã®å 容ãšåæãããŸãã
-
ããªã³ã¯ãããéžæã®äœçœ®ãã§ã¯ããªã¹ãããã¯ã¹ã®åäžéžæé ç®ã®äœçœ®ããã»ã«ã®æ°å€ã«åæãããŸãã
ã¢ã¯ã·ã§ã³ |
çµæ |
åäžã®ãªã¹ãé ç®ãéžæ |
ãå 容ããªã³ã¯ãã§ã¯ãé ç®ã®ããã¹ãããªã³ã¯ãããã»ã«ã«ã³ããŒãããŸãã ãéžæããªã³ã¯ãã§ã¯ãéžæé ç®ã®äœçœ®ããªã³ã¯ãããã»ã«ã«ã³ããŒãããŸããããšãã°ã3 çªç®ã®é ç®ãéžæãããšãæ°å€ 3 ãã³ããŒãããŸãã |
è€æ°ãªã¹ãé ç®ãéžæ |
ãªã³ã¯ãããã»ã«ã« #NV ãå ¥å |
å šãªã¹ãé ç®ãéžæè§£é€ |
ãå 容ããªã³ã¯ãã§ã¯ããªã³ã¯ãããã»ã«ãã¯ãªã¢ ãéžæããªã³ã¯ãã§ã¯ããªã³ã¯ãããã»ã«ã« 0 ãå ¥å |
ãªã³ã¯ãããã»ã«ã«ããã¹ããŸãã¯æ°å€ãå ¥å |
ãå 容ããªã³ã¯ãã§ã¯ãçãããªã¹ãé ç®ãæ€çŽ¢ããŠéžæ ãéžæããªã³ã¯ãã§ã¯ãæå®äœçœ® (å é ã®é ç®ã¯ 1 ã§ã) ã«ããé ç®ãéžæãããŸããèŠã€ãããªãå Žåã¯ãã©ã®é ç®ãéžæãããŸããã |
ãªã³ã¯ãããã»ã«ã«æ°åŒãå ¥å |
æ°åŒã®çµæããã³ãªã³ã¯ã¢ãŒãã«ããããããªã¹ãé ç®ãæ€çŽ¢ããŠéžæ |
ãªã³ã¯ãããã»ã«ãã¯ãªã¢ |
ãªã¹ãããã¯ã¹ã®å šãªã¹ãé ç®ãéžæè§£é€ |
ãªã¹ãã®ãœãŒã¹ç¯å²ã®å 容ãå€æŽ |
倿Žã«å¿ããŠããªã¹ãããã¯ã¹ã®é ç®ãæŽæ°ãããŸããéžæç¶æ ã¯ä¿ãããŸãããã®çµæãªã³ã¯ãããã»ã«ãæŽæ°ãããå ŽåããããŸãã |
ãªã³ã¯ãããã»ã«ã®ããã³ã³ãããã¯ã¹
ã¢ã¯ã·ã§ã³ |
çµæ |
ã³ã³ãããã¯ã¹ã®ç·šéãã£ãŒã«ãã«ããã¹ããå ¥åããããããããããŠã³ãªã¹ãããé ç®ãéžæ |
ããã¹ãããªã³ã¯ãããã»ã«ã«ã³ã㌠|
ã³ã³ãããã¯ã¹ã®ç·šéãã£ãŒã«ããã¯ãªã¢ |
ãªã³ã¯ãããã»ã«ãã¯ãªã¢ |
ãªã³ã¯ãããã»ã«ã«ããã¹ããŸãã¯æ°å€ãå ¥å |
ããã¹ããŸãã¯æ°å€ããã³ã³ãããã¯ã¹ã®ç·šéãã£ãŒã«ãã«ã³ã㌠|
ãªã³ã¯ãããã»ã«ã«æ°åŒãå ¥å |
æ°åŒã®çµæããã³ã³ãããã¯ã¹ã®ç·šéãã£ãŒã«ãã«ã³ã㌠|
ãªã³ã¯ãããã»ã«ãã¯ãªã¢ |
ã³ã³ãããã¯ã¹ã®ç·šéãã£ãŒã«ããã¯ãªã¢ |
ãªã¹ãã®ãœãŒã¹ç¯å²ã®å 容ãå€æŽ |
倿Žã«å¿ããŠãããããããŠã³ãªã¹ãã®é ç®ãæŽæ°ãããŸããã³ã³ãããã¯ã¹ã®ç·šéãã£ãŒã«ãããã³ãªã³ã¯ãããã»ã«ã¯å€æŽãããŸããã |
ãªã³ã¯ãããã»ã«ã®å 容
衚èšç®ããã¥ã¡ã³ãã«ãããªã³ã¯ãããã»ã«ã䜿çšããŠãªã¹ãããã¯ã¹ããªã³ã¯ãããæã®ã¢ãŒããéžæããŸãã
-
ããªã³ã¯ãããå 容ãã§ã¯ããªã¹ãããã¯ã¹ã®éžæããé ç®ã®å 容ããã»ã«ã®å 容ãšåæãããŸãããéžææžã¿é ç®ããéžæ
-
ããªã³ã¯ãããéžæã®äœçœ®ãã§ã¯ããªã¹ãããã¯ã¹ã®åäžéžæé ç®ã®äœçœ®ããã»ã«ã®æ°å€ã«åæãããŸãããéžææžã¿é ç®ã®äœçœ®ããéžæ
åç §å€ (ãªã)
衚èšç®ããã¥ã¡ã³ãå ã®ãã§ãã¯ããã¯ã¹ããã³ã©ãžãªãã¿ã³ã¯ãçŸåšã®ããã¥ã¡ã³ãã®ã»ã«ã«ãã€ã³ãã§ããŸãã ãã®ã³ã³ãããŒã«ãæå¹ã§ããå Žåãåç §å€ã«å ¥åããå€ (on) ãã»ã«ã«ã³ããŒãããŸãã ãã®ã³ã³ãããŒã«ãç¡å¹ã§ããå Žåãåç §å€ã®å€ (off) ãã»ã«ã«ã³ããŒãããŸãã
åç §å€ (ãªã³)
åç §å€ã¯ããªãã·ã§ã³ããã¯ã¹ãšãã§ãã¯ããã¯ã¹ã«å²ãåœãŠãããšãã§ããŸããåç §å€ã¯ããã©ãŒã ã®éä¿¡æã«ãµãŒããŒã«éãããŸããããŒã¿ããŒã¹ãã©ãŒã ã®å Žåãããã«å ¥åãããå€ã¯ã³ã³ãããŒã«ãã£ãŒã«ãã«å²ãåœãŠãããããŒã¿ããŒã¹å ã«æžã蟌ãŸããŸãã
Web ãã©ãŒã ããã®åç §å€
Web ãã©ãŒã ããã¶ã€ã³ããã³ã³ãããŒã«ã®ã¹ããŒã¿ã¹ã«é¢ããæ å ±ããµãŒããŒã«è»¢éããå Žåã«ãåç §å€ãæå¹ã§ãã ãŠãŒã¶ãŒãã³ã³ãããŒã«ãã¯ãªãã¯ãããšãããã«å¯Ÿå¿ããåç §å€ããµãŒããŒã«éä¿¡ãããŸãã
äŸãã°ããªãã·ã§ã³ã女æ§ãããç·æ§ãã«å¯Ÿå¿ãã 2 ã€ã®ã³ã³ãããŒã«ãã£ãŒã«ãããããåç §å€ 1 ããã£ãŒã«ãã女æ§ããåç §å€ 2 ããã£ãŒã«ããç·æ§ãã«å²ãåœãŠãŸãããŠãŒã¶ãŒããã£ãŒã«ãã女æ§ããã¯ãªãã¯ãããšå€ 1 ããµãŒããŒã«éä¿¡ããããã£ãŒã«ããç·æ§ããã¯ãªãã¯ãããšå€ 2 ãéä¿¡ãããŸãã
ããŒã¿ããŒã¹ãã©ãŒã ã®å Žåã®åç §å€
ããŒã¿ããŒã¹ãã©ãŒã ã®å Žåããªãã·ã§ã³ãã£ãŒã«ããããã¯ãã§ãã¯ããã¯ã¹ã®ã¹ããŒã¿ã¹ãåæ§ã«åç §å€ã§èå¥ãããã®åç §å€ãããŒã¿ããŒã¹ã«ä¿åã§ããŸããããšãã°ãïŒã€ã®ãªãã·ã§ã³ãäœæ¥äžãããåŠçæžã¿ãããã³ãåæåºããã°ã«ãŒãåããããããã«ãåç §ãToDoãããOKãããã³ãWVããå²ãåœãŠãŠããå Žåãããããã®ãªãã·ã§ã³ãã¯ãªãã¯ãããšãããŒã¿ããŒã¹ã®ãããã®åç §å€ã衚瀺ãããŸãã
ç©ºã®æåå㯠NULL ãšã¿ãªã
ã¯ã空çœã®æååã®æ±ããå®çŸ©ããŸããYes ã«èšå®ãããŠãããšé·ããŒãã®æååãå ¥åãããš NULL å€ãšããŠæ±ãããŸããNo ã«èšå®ãããŠãããšãå ¥åãããå€ã¯ãã®ãŸãŸäœã®å€æããããã«æ±ãããŸãã
空çœã®æååãšã¯é·ãããŒãã®æååã§ã("")ãéåžžã¯ãNULL å€ã¯ç©ºçœæååãšã¯å¥ç©ã§ããäžè¬çã«ãNULL ãšããèšèã¯æªå®çŸ©ã®å€ãšãã äžå®ã®å€ããŸã㯠"äœãå€ãå ¥ã£ãŠããªã"ãæå³ããŸãã
ããŒã¿ããŒã¹ã·ã¹ãã ã¯ããããç°ãªããŸããããããããNULL å€ãå¥ã ã«æ±ã£ãŠããŸããã䜿ãã®ããŒã¿ããŒã¹ã·ã¹ãã ã®ããã¥ã¡ã³ããåç §ããŠãã ããã
é¢é£ãããã£ãŒã«ã

ããããã£ãã©ãŠã¶ãŒå ã® å¢çãã£ãŒã«ã ã»ã«ã®å 容ãåé€ãããšãããŒã¿ã®è¡šç€ºãšäº€æçšã«çµæã»ããã®æåã®ãã£ãŒã«ãã䜿çšãããŸãã
ãªã¹ãããã¯ã¹ã«äœ¿ãã屿§ã«ããããªã³ã¯ããŠããããŒãã«ã®ã©ã®ããŒã¿ãã£ãŒã«ãããã©ãŒã ã«è¡šç€ºããããæ±ºãŸããŸãã
ãã©ãŒã å ã®ãªã¹ãããã¯ã¹ã«ããã©ãŒã ããŒãã«ãšãªã³ã¯ããŠããããŒãã«ã®å 容ã衚瀺ããã«ã¯ããªã¹ãã®å 容ã®çš®é¡ ãã£ãŒã«ãã§ãSQLã³ãã³ããä»ããŠè¡šç€ºããããããããã¯ãã®éã(ãªã³ã¯ããŠãã)ããŒãã«ã«é¡ã£ãŠã¢ã¯ã»ã¹ããããæå®ããŸããé¢é£ãããã£ãŒã«ã 屿§ã§ãã€ã³ããã¯ã¹ã䜿ã£ãŠãã¯ãšãªãŒãããã¯ããŒãã«ã®ã©ã®ããŒã¿ãã£ãŒã«ããšãªã¹ãããã¯ã¹ããªã³ã¯ããŠããããæå®ããŸãã

é¢é£ãããã£ãŒã«ã 屿§ã¯ãè€æ°ã®ããŒãã«ã«ã¢ã¯ã»ã¹ãããã©ãŒã ã«å¯ŸããŠã®ã¿äœ¿çšããŸããåç¬ã®ããŒãã«ã®ã¿ã䜿çšãããã©ãŒã ã®å Žåããã©ãŒã ã«è¡šç€ºãããã£ãŒã«ãã¯ãããŒã¿ãã£ãŒã«ã ã«æå®ããŸãããªã¹ãããã¯ã¹ã«è¡šç€ºãããããŒã¿ããå ±éããŒã¿ãã£ãŒã«ããä»åšããŠçŸåšã®ããŒãã«ã«ãªã³ã¯ããããŒãã«ããèªã¿åºããå Žåã¯ããªã³ã¯ããããŒã¿ãã£ãŒã«ãã é¢é£ãããã£ãŒã«ã 屿§ã«æå®ããŸãã
ãªã¹ãã®å 容ã®çš®é¡ ã§ãsqlããéžæããå Žåã¯ãSQL ã³ãã³ãã«ããã€ã³ããã¯ã¹ãæå®ããŸããäŸ:SQL ã³ãã³ããšã㊠ãªã¹ãã®å 容 ã«ãSELECT Field1, Field2 FROM tablenameãã®ããã«æå®ãããšãããŒãã«ã¯äžèšã®ããã«åç §ãããŸãã
é¢é£ãããã£ãŒã«ã |
ãªã³ã¯ |
-1 |
The index of the selected entry in the list is linked to the field specified under Data field. |
{empty} or 0 |
ããŒã¿ããŒã¹ãã£ãŒã«ããFeld1ãã¯ãããŒã¿ãã£ãŒã«ã ã§å ¥åãããã£ãŒã«ãã«ãªã³ã¯ãããŠããŸãã |
1 |
ããŒã¿ããŒã¹ãã£ãŒã«ããFeld2ãã¯ãããŒã¿ãã£ãŒã«ã ã§å ¥åãããã£ãŒã«ãã«ãªã³ã¯ãããŠããŸãã |
ãªã¹ãã®å 容ã®çš®é¡ ã§ãããŒãã«ããéžæããå Žåã¯ã䜿çšããã€ã³ããã¯ã¹ã¯ããŒãã«æ§é ã«ããèŠå®ãããŸããäŸ:ãªã¹ãã®å 容 ã§ããŒã¿ããŒã¹ããŒãã«ãéžæããå ŽåãããŒãã«ã¯äžèšã®ããã«åç §ãããŸãã
é¢é£ãããã£ãŒã«ã |
ãªã³ã¯ |
-1 |
The index of the selected entry in the list is linked to the field specified under Data field. |
{empty} or 0 |
ããŒãã«ã®ç¬¬ïŒåã¯ãããŒã¿ãã£ãŒã«ã ã§å ¥åãããã£ãŒã«ãã«ãªã³ã¯ããŠããŸãã |
1 |
ããŒãã«ã®ç¬¬ïŒåã¯ãããŒã¿ãã£ãŒã«ã ã§å ¥åãããã£ãŒã«ãã«ãªã³ã¯ããŠããŸãã |
2 |
ããŒãã«ã®ç¬¬ïŒåã¯ãããŒã¿ãã£ãŒã«ã ã§å ¥åãããã£ãŒã«ãã«ãªã³ã¯ããŠããŸãã |