1. 128219405294622177174.zip Driver
2. adoxrdme.txt File Contents

adoxrdme.txt Driver File Contents (128219405294622177174.zip)

---------------------------------------------------------
Microsoft ActiveX(R) Data Objects Extensions for DDL and Security
Ū§ÚÀÉ®×
---------------------------------------------------------

(c) 1998 Microsoft Corporation. All rights reserved.

¦¹¤å¥ó´£¨Ñ³Ì·s©Î¨ä¥¦¸ê°T¡A¸É¨¬ Microsoft ADO Extensions for DDL 
and Security (ADOX) ¤â¥U¤£¨¬ªº³¡¥÷¡C

--------
¤º®e
--------

1. ²£«~»¡©ú
   
2. ¥\¯à
   
3. §Þ³Nª`·N¨Æ¶µ

4. ¤wª¾°ÝÃD¡B­­¨î©M¸Ñ¨M¤èªk

----------------------
1. ²£«~»¡©ú
----------------------

Microsoft® ActiveX® Data Objects Extensions for Data Definition Language and
Security (ADOX) ¬O ADO ª«¥ó©Mµ{¦¡³]­p¼Ò¦¡ªº©µ¦ù¡CADOX ¥]¬A¥Î©ó«Ø¥ß»P­×§ïµ²ºc
±Ô­z (schema) ¥H¤Î¦w¥þ©Êªºª«¥ó¡C¦]¬°¥¦¬O¥Hª«¥ó¬°°ò¦ªºµ²ºc±Ô­z±±¨î¤èªk¡A±z
¥i¥H¼¶¼g¯à¦b¤£¦P¸ê®Æ¨Ó·½°õ¦æªºµ{¦¡½X¡A¤£½×­ì¥Í½X»yªk¦³¤°»ò®t²§©Ê¡C

---------------
2. ¥\¯à
---------------

ADOX ¬O ADO ®Ö¤ßª«¥ó·f°tªºµ{¦¡®w¡C¥¦·|Åã¥ÜÃB¥~ª«¥ó¡A¥Î¨Ó«Ø¥ß¡B­×§ï©M§R°£
µ²ºc±Ô­zª«¥ó¡A¨Ò¦pªí®æ©Mµ{§Ç¡C

------------------
3. §Þ³Nª`·N¨Æ¶µ
------------------

3.1 ¥²­n/¿ï¥Îªºªí®æ¡B¯Á¤Þ¥H¤Î¸ê®Æ¦æÄÝ©Ê

±zªº¸ê®Æ´£¨ÑªÌ (provider) ¤£§¹¥þ¥i¥H¤ä´©©Ò¦³ªí®æ¡B¯Á¤Þ¥H¤Î¸ê®Æ¦æª«¥óªºÄÝ©Ê¡C
¦pªG¬°´£¨ÑªÌ¤£¤ä´©ªºÄݩʳ]©w¤F¬Y­Ó­È¡A´N·|µo¥Í¿ù»~¡C¦b·sªºªí®æ¡B
¯Á¤Þ©Î¸ê®Æ¦æ¤è­±¡A·íª«¥ó³Qªþ¥[¨ì¶°¦Xª«¥ó®É´N·|µo¥Í¿ù»~¡C¦Ü©ó²{¦³
ªºª«¥ó¡A¦b³]©wÄݩʪº®É­Ô·|µo¥Í¿ù»~¡C

«Ø¥ßªí®æ¡B¯Á¤Þ©Î¸ê®Æ¦æª«¥óªº®É­Ô¡A¿ï¥Î©ÊÄݩʪº¾A·í¹w³]­ÈµLªk«OÃÒ
±zªº´£¨ÑªÌ·|¤ä´©¸ÓÄÝ©Ê¡C¦p»Ý´£¨ÑªÌ¤ä´©ªºÄݩʸԲӸê°T¡A½Ð°Ñ¾\±zªº
´£¨ÑªÌ¤â¥U¡C

3.2 ±N ADOX »P Microsoft OLE DB Providers ¤@°_¨Ï¥Î

¨Ì·Ó±zªº OLE DB ¸ê®Æ´£¨ÑªÌ¤£¦P¡A¤£¤ä´©¯S©wªº ADOX ¥\¯à¡CMicrosoft OLE DB 
Provider for the Microsoft Jet Database Engine §¹¥þ¤ä´© ADOX¡C¦Ü©ó Microsoft
SQL Server OLE DB Provider¡BMicrosoft OLE DB Provider for ODBC ©Î
Microsoft OLE DB Provider for Oracle ¤è­±¡A½Ð°Ñ¾\¤U¦C¡C¥ô¦ó¨ä¥¦ªº Microsoft
OLE DB ´£¨ÑªÌ¤£¤ä´© ADOX¡C

Microsoft SQL Server OLE DB Provider

°£¤F¦b¦¹©Ò¦C¤§¥~¡A¥i¥H¤ä´©©Ò¦³ ADOX ª«¥ó¡B¶°¦Xª«¥ó¡BÄÝ©Ê©M¤èªk¡G

Ãþ§O¡GCreate ¤èªk¡C
ªí®æ¡G²{¦³ªí®æªºÄݩʬO°ßŪ (·sªí®æªºÄÝ©Ê¥i¥H¬OŪ/¼g)¡C
À˵ø¡G¤£¤ä´©¡C
µ{§Ç¡GAppend ¤èªk¡BDelete ¤èªk¡BCommand ÄÝ©Ê¡C
«öÁä¡GAppend ¤èªk¡BDelete ¤èªk¡C
¨Ï¥ÎªÌ¡G¤£¤ä´©¡C
¸s²Õ¡G¤£¤ä´©¡C

Microsoft OLE DB Provider for ODBC

°£¤F¦b¦¹©Ò¦C¤§¥~¡A¥i¥H¤ä´©©Ò¦³ ADOX ª«¥ó¡B¶°¦Xª«¥ó¡BÄÝ©Ê©M¤èªk¡G

Ãþ§O¡GCreate ¤èªk¡C
ªí®æ¡GAppend ¤èªk¡BDelete ¤èªk¡C²{¦³ªí®æªºÄݩʬO°ßŪ 
(·sªí®æªºÄÝ©Ê¥i¥H¬OŪ/¼g)¡C
À˵ø¡GAppend ¤èªk¡BDelete ¤èªk¡BCommand ÄÝ©Ê¡C
µ{§Ç¡GAppend ¤èªk¡BDelete ¤èªk¡BCommand ÄÝ©Ê¡C
¯Á¤Þ¡GAppend ¤èªk¡BDelete ¤èªk¡C
«öÁä¡GAppend ¤èªk¡BDelete ¤èªk¡C
¨Ï¥ÎªÌ¡G¤£¤ä´©¡C
¸s²Õ¡G¤£¤ä´©¡C


Microsoft OLE DB Provider for Oracle

°£¤F¦b¦¹©Ò¦C¤§¥~¡A¥i¥H¤ä´©©Ò¦³ ADOX ª«¥ó¡B¶°¦Xª«¥ó¡BÄÝ©Ê©M¤èªk¡G

Ãþ§O¡GCreate ¤èªk¡C
ªí®æ¡GAppend ¤èªk¡BDelete ¤èªk¡C²{¦³ªí®æªºÄݩʬO°ßŪ 
(·sªí®æªºÄÝ©Ê¥i¥H¬OŪ/¼g)¡C
À˵ø¡GAppend ¤èªk¡BDelete ¤èªk¡BCommand ÄÝ©Ê¡C
µ{§Ç¡GAppend ¤èªk¡BDelete ¤èªk¡BCommand ÄÝ©Ê¡C
¯Á¤Þ¡GAppend ¤èªk¡BDelete ¤èªk¡C
«öÁä¡GAppend ¤èªk¡BDelete ¤èªk¡C
¨Ï¥ÎªÌ¡G¤£¤ä´©¡C
¸s²Õ¡G¤£¤ä´©¡C


-----------------
4. ¤wª¾°ÝÃD¡B­­¨î©M¸Ñ¨M¤èªk
-----------------

¤U¦C¬O ADOX ¤wª¾°ÝÃD²M³æ¡G

4.1 DateCreated/DateModified Äݩʻݭn Refresh

¦b·sªþ¥[ªºª«¥ó¤¤¡ADateCreated ©M DateModified ÄݩʬO NULL¡C
ªþ¥[·s View ©Î Procedure ®É¡A¥²¶·©I¥s View ©Î Procedure ¶°¦Xª«¥óªº 
Refresh ¤èªk¡A¥H«K¨ú±o DateCreated ©M DateModified Äݩʪº­È¡C

4.2 Index ª«¥ó¨S¦³ ParentCatalog ÄÝ©Ê

¦b ADOX »¡©ú¤¤¡AParentCatalog ³Q»~¦C¦¨ Index ª«¥óªºÄÝ©Ê¡CParentCatalog
¹ê»Ú¤W¬O¥u¬O Column ©M Table ª«¥óªºÄÝ©Ê¡C

4.3 adAccessRevoke ¨ú¥N SetPermissions ªº Rights °Ñ¼Æ

©I¥s Group ©Î User ªº SetPermissions ¤èªk®É¡A±N Actions °Ñ¼Æ³]¦¨
adAccessRevoke ·|¨ú¥N Rights °Ñ¼Æªº¥ô¦ó­È¡C¦pªG·QÅý Rights °Ñ¼Æ¤º
«ü©wªºÅv­­¥Í®Ä¡A½Ð¤£­n±N Actions ³]¦¨ adAccessRevoke¡C

4.4 Append ¤èªkªº RelatedColumn °Ñ¼Æ (Keys ¶°¦Xª«¥ó)

Key ¶°¦Xª«¥óªº Appen ¤èªk¤å¥óÀ³¸Ó¥]§t¤@­Ó¿ï¥Îªº²Ä 4 ­Ó°Ñ¼Æ - RelatedColumn¡C
§ó·sªº»yªk¬°:

Keys.Append Key [, KeyType] [, Column] [, RelatedTable] [, RelatedColumn]

RelatedColumn °Ñ¼Æ¬O¿ï¥Îªº¡CRelatedColumn ¬O¤@­Ó String ­È¡A¥¦¥i¥H«ü©w
foreign key ªº¬ÛÃöÄæ¦ì¦WºÙ¡CRelatedTable °Ñ¼Æ¥i¥H¹ïÀ³¦Ü Column ª«¥óªº Name ÄÝ©Ê©Ê¡C

4.5 IndexNulls Äݩʪº adIndexNullsAllow Enum ­È

Index ª«¥óªº IndexNulls Äݩʤå¥óÀ³¸Ó¦b¦³®Ä­Èªí®æ¥]§t¤@©Î¦h­Ó Enum ±`¼Æ:

adIndexNullsAllow     ¦¹¯Á¤Þ¤£¤¹³\ÃöÁäÄæ¦ì¬° Null ®É¿é¤J¸ê®Æ¡C­Y¦bÃöÁä
Äæ¦ì¿é¤J Null ­È¡A¿é¤Jªº¸ê®Æ·|³Q´¡¨ì¯Á¤Þ¡C