¿ÀÌî¤Ç¤¹¡£

Wed, 12 Apr 2000 20:20:19 +1000 ¤´¤í¤Ë
<38F44DE338E.BAF2HIRO@xxxxxxxxxx> ¤Î
"[mysql 01881] Re: Access ¤«¤é¤Î¥¨¥¯¥¹¥Ý¡¼¥È¥¨¥é¡¼" ¤Î¥á¡¼¥ë¤Ç
Hirotaka Kondo ¶áÆ£¿Òδ <hiro@xxxxxxxxxx> ¤µ¤ó¤Ï½ñ¤­¤Þ¤·¤¿¡£

Access2000¤Ç¤ä¤Ã¤Æ¤ß¤Þ¤·¤¿¡£(MyODBC 2.50.15b)
¥¨¥¯¥¹¥Ý¡¼¥È¤¹¤ë¤È¡¢¤³¤ó¤Ê¥¨¥é¡¼¤Ë¤Ê¤Ã¤Æ¤·¤Þ¤¤¤Þ¤¹¡£

| ODBC--¸Æ¤Ó½Ð¤·¤¬¼ºÇÔ¤·¤Þ¤·¤¿¡£
| [Microsoft][ODBC Driver M (#0)

> >CREATE TABLE  ( varchar(50))
> ¤È¤Ê¤Ã¤Æ¤¤¤ë¤³¤È¤¬Ê¬¤«¤ê¤Þ¤·¤¿¡£¥Æ¡¼¥Ö¥ë̾¤È¥Õ¥£¡¼¥ë¥É̾¤¬Æþ¤Ã¤Æ¤¤¤Þ¤»¤ó¡£
> ¤³¤¦¤Ê¤ëÍýͳ¤¬Á´¤¯Ê¬¤«¤ê¤Þ¤»¤ó¡£

¥í¥°¸«¤ë¤ÈƱ¤¸¤Ç¤¹¡£

¤½¤ê¤ã¤¡¡¢¥¨¥é¡¼¤Ë¤Ê¤Ã¤Æ¤â»ÅÊý¤Ê¤¤¤Ç¤¹¤Í¡£
¡ôAccess¤Î¥á¥Ã¥»¡¼¥¸¤Ï°ÕÌ£ÉÔÌÀ¤Ç¤¹¤±¤É¡£

ÌäÂê¤Ï¡¢¤Ê¤ó¤ÇAccess¤¬¤½¤ó¤ÊSQLʸ¤òÅꤲ¤Ä¤±¤ë¤Î¤«¡©¤Ç¤¹¡£

SQLExecDirect( "CREATE TABLE ..." )
¤ÎÁ°¤Ë¡¢
SQLGetTypeInfo( SQL_ALL_TYPES )  /* fSqlType: 0 */
SQLGetInfo( SQL_DBMS_NAME )  /* fInfoType: 17 */
SQLGetInfo( ¾¤¤¤í¤¤¤í )
¤È¤«¡¢¤ä¤Ã¤Æ¤¤¤ë¤ß¤¿¤¤¤Ç¤¹¡£
¤½¤Î¤É¤ì¤«¤ò¡Ö¥Æ¡¼¥Ö¥ë̾¤ä¥Õ¥£¡¼¥ë¥É̾¤ò¾Êά¤Ç¤­¤ë¡×¤È¤¤¤¦É÷¤Ë
Access¤¬¸íǧ¤·¤Æ¤¤¤ë¤Î¤«¡©¤È¤¤¤¦¤Î¤¬°ì¤Ä¤Î¿äÍý¤Ç¤¹¡£

SQLGetInfo()¤Ï¤¤¤í¤ó¤Êµ¡Ç½¤¬¤¢¤Ã¤Æ¡¢Á´Éô¤òÄ´¤Ù¤­¤ì¤Æ¤Ï¤¤¤Ê¤¤
¤Î¤Ç¤¹¤¬¡¢¥í¥°¤Ëµ­Ï¿¤µ¤ì¤Æ¤¤¤ë¸Æ¤Ó½Ð¤·¤ÎÃæ¤Ë¤Ï¡¢¡Ö¾Êά¤Ç¤­¤ë¡×
¤È¤¤¤¦¤è¤¦¤Ê¾ðÊó¤Ï̵¤¤¤è¤¦¤Ç¤¹¡£

¤Ç¡¦¡¦¡¦¡¦
¤Õ¤È¡¢¤¢¤ó¤Þ¤ê^H^H^H^H¤Û¤È¤ó¤É¿¿·õ¤ËÆɤó¤Ç¤Ê¤«¤Ã¤¿¡¢ËܲȤÎ
MyODBC ML¤òÆɤßÊÖ¤·¤Æ¤ß¤¿¤é¡¢Access2000¤ÇƱÍͤÎÌäÂ꤬
¿¿ôÊó¹ð¤µ¤ì¤Æ¤¤¤Þ¤¹¡£¤É¤¦¤âAccess2000¤ËÌäÂꤢ¤ë¤è¤¦¤Ç¤¹¡£
¡ÖºÇ¿·¤Î¥Ñ¥Ã¥Á(¤Ã¤Æ¤¢¤ë¤Î¡©)¤¢¤Æ¤Æ¤â¥À¥á¤À¤Ã¤¿¡×¤È¤«
¡Ö97¤ò»È¤¨¡×¤È¤«¡¢¸À¤ï¤ì¤Æ¤Þ¤¹(^_^;

-----------------------------
¿ÀÌî·ò¸ã <kengo@xxxxxxxxxx>