{"id":248,"date":"2012-05-29T00:50:54","date_gmt":"2012-05-29T00:50:54","guid":{"rendered":"621bf66ddb7c962aa0d22ac97d69b793"},"modified":"2012-05-29T00:50:54","modified_gmt":"2012-05-29T00:50:54","slug":"","status":"publish","type":"post","link":"https:\/\/www.xiaobo.li\/notes\/archives\/248","title":{"rendered":"ADO RS.OPEN"},"content":{"rendered":"

recordset.Open Source,ActiveConnection,CursorType,LockType,Options <\/p>\n

\u53ef\u4ee5\u5199\u6210\uff1a
\nrs.open SQL\u8bed\u53e5,conn\u5bf9\u8c61,3\uff08\u6e38\u6807\u7c7b\u578b\uff09,2\uff08\u9501\u5b9a\u65b9\u6cd5\uff09 <\/p>\n

Source<\/strong>
\nRecordset\u5bf9\u8c61\u53ef\u4ee5\u901a\u8fc7Source\u5c5e\u6027\u6765\u8fde\u63a5Command\u5bf9\u8c61\u3002Source\u53c2\u6570\u53ef\u4ee5\u662f\u4e00\u4e2aCommand\u5bf9\u8c61\u540d\u79f0\u3001\u4e00\u6bb5SQL\u547d\u4ee4\u3001\u4e00\u4e2a\u6307\u5b9a\u7684\u6570\u636e\u8868\u540d\u79f0\u6216\u662f\u4e00\u4e2aStored Procedure\u3002\u5047\u5982\u7701\u7565\u8fd9\u4e2a\u53c2\u6570\uff0c\u7cfb\u7edf\u5219\u91c7\u7528Recordset\u5bf9\u8c61\u7684Source\u5c5e\u6027\u3002 <\/p>\n

ActiveConnection<\/strong>
\nRecordset\u5bf9\u8c61\u53ef\u4ee5\u901a\u8fc7ActiveConnection\u5c5e\u6027\u6765\u8fde\u63a5Connection\u5bf9\u8c61\u3002\u8fd9\u91cc\u7684ActiveConnection\u53ef\u4ee5\u662f\u4e00\u4e2aConnection\u5bf9\u8c61\u6216\u662f\u4e00\u4e32\u5305\u542b\u6570\u636e\u5e93\u8fde\u63a5\u4fe1\u606f\uff08ConnectionString\uff09\u7684\u5b57\u7b26\u4e32\u53c2\u6570\u3002 <\/p>\n

<\/span>CursorType
\n<\/strong>Recordset\u5bf9\u8c61Open\u65b9\u6cd5\u7684CursorType\u53c2\u6570\u8868\u793a\u5c06\u4ee5\u4ec0\u4e48\u6837\u7684\u6e38\u6807\u7c7b\u578b\u542f\u52a8\u6570\u636e\uff0c\u5305\u62ecadOpenForwardOnly\u3001adOpenKeyset\u3001adOpenDynamic\u53caadOpenStatic\uff0c\u5206\u8ff0\u5982\u4e0b\uff1a
\n<\/span> <\/p>\n\n\n\n\n\n\n\n
\u5e38\u6570 <\/span><\/td>\n\u5e38\u6570\u503c<\/span> <\/td>\n \u8bf4\u660e<\/span> \n<\/td>\n<\/tr>\n
adOpenForwardOnly<\/span> <\/td>\n0\u7f3a\u7701\u503c<\/span> <\/td>\n\u542f\u52a8\u4e00\u4e2a\u53ea\u80fd\u5411\u524d\u79fb\u52a8\u7684\u6e38\u6807\uff08Forward Only\uff09<\/span> <\/td>\n<\/tr>\n
adOpenKeyset<\/span> <\/td>\n1<\/td>\n\u542f\u52a8\u4e00\u4e2aKeyset\u7c7b\u578b\u7684\u6e38\u6807<\/span> <\/td>\n<\/tr>\n
adOpenDynamic <\/span><\/td>\n2<\/td>\n\u542f\u52a8\u4e00\u4e2aDynamic\u7c7b\u578b\u7684\u6e38\u6807<\/span> <\/td>\n<\/tr>\n
adOpenStatic <\/span><\/td>\n3<\/td>\n\u542f\u52a8\u4e00\u4e2aStatic\u7c7b\u578b\u7684\u6e38\u6807<\/span> <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n-------------------------------------------------------------
\n\u4ee5\u4e0a\u51e0\u4e2a\u6e38\u6807\u7c7b\u578b\u5c06\u76f4\u63a5\u5f71\u54cd\u5230Recordset\u5bf9\u8c61\u6240\u6709\u7684\u5c5e\u6027\u548c\u65b9\u6cd5\uff0c\u4ee5\u4e0b\u5217\u8868\u8bf4\u660e\u4ed6\u4eec\u4e4b\u95f4\u7684\u533a\u522b\u3002 <\/p>\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n\n
Recordset\u5c5e\u6027 <\/span><\/td>\nadOpenForwardOnly <\/span><\/td>\nadOpenKeyset <\/span><\/td>\nadOpenDynamic <\/span><\/td>\nadOpenStatic<\/span> <\/td>\n<\/tr>\n
AbsolutePage  <\/span><\/td>\n\u4e0d\u652f\u6301 <\/span> <\/td>\n\u4e0d\u652f\u6301 <\/span> <\/td>\n\u53ef\u8bfb\u5199<\/span> <\/td>\n\u53ef\u8bfb\u5199<\/span> <\/td>\n<\/tr>\n
AbsolutePosition<\/td>\n\u4e0d\u652f\u6301<\/td>\n\u4e0d\u652f\u6301<\/td>\n\u53ef\u8bfb\u5199<\/td>\n\u53ef\u8bfb\u5199<\/td>\n<\/tr>\n
ActiveConnection<\/td>\n\u53ef\u8bfb\u5199 <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n<\/tr>\n
BOF<\/td>\n\u53ea\u8bfb<\/td>\n\u53ea\u8bfb<\/td>\n\u53ea\u8bfb<\/td>\n\u53ea\u8bfb<\/td>\n<\/tr>\n
Bookmark<\/td>\n\u4e0d\u652f\u6301 <\/td>\n\u4e0d\u652f\u6301 <\/td>\n\u53ef\u8bfb\u5199<\/td>\n\u53ef\u8bfb\u5199<\/td>\n<\/tr>\n
CacheSize<\/td>\n\u53ef\u8bfb\u5199<\/td>\n\u53ef\u8bfb\u5199<\/td>\n\u53ef\u8bfb\u5199<\/td>\n\u53ef\u8bfb\u5199<\/td>\n<\/tr>\n
CursorLocation <\/td>\n\u53ef\u8bfb\u5199<\/td>\n\u53ef\u8bfb\u5199<\/td>\n\u53ef\u8bfb\u5199<\/td>\n\u53ef\u8bfb\u5199<\/td>\n<\/tr>\n
CursorType <\/td>\n\u53ef\u8bfb\u5199<\/td>\n\u53ef\u8bfb\u5199<\/td>\n\u53ef\u8bfb\u5199<\/td>\n\u53ef\u8bfb\u5199<\/td>\n<\/tr>\n
EditMode <\/td>\n\u53ea\u8bfb <\/td>\n\u53ea\u8bfb <\/td>\n\u53ea\u8bfb <\/td>\n\u53ea\u8bfb <\/td>\n<\/tr>\n
EOF <\/td>\n\u53ea\u8bfb <\/td>\n\u53ea\u8bfb <\/td>\n\u53ea\u8bfb <\/td>\n\u53ea\u8bfb <\/td>\n<\/tr>\n
Filter <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n<\/tr>\n
LockType <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n<\/tr>\n
MarshalOptions <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n<\/tr>\n
MaxRecords <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n<\/tr>\n
PageCount <\/td>\n\u4e0d\u652f\u6301 <\/td>\n\u4e0d\u652f\u6301 <\/td>\n\u53ea\u8bfb <\/td>\n\u53ea\u8bfb <\/td>\n<\/tr>\n
PageSize <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n<\/tr>\n
RecordCount <\/td>\n\u4e0d\u652f\u6301 <\/td>\n\u4e0d\u652f\u6301 <\/td>\n\u53ea\u8bfb <\/td>\n\u53ea\u8bfb <\/td>\n<\/tr>\n
Source <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n\u53ef\u8bfb\u5199 <\/td>\n<\/tr>\n
State <\/td>\n\u53ea\u8bfb<\/td>\n\u53ea\u8bfb<\/td>\n\u53ea\u8bfb<\/td>\n\u53ea\u8bfb<\/td>\n<\/tr>\n
Status <\/td>\n\u53ea\u8bfb<\/td>\n\u53ea\u8bfb<\/td>\n\u53ea\u8bfb<\/td>\n\u53ea\u8bfb<\/td>\n<\/tr>\n
AddNew <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n<\/tr>\n
CancelBatch <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n<\/tr>\n
CancelUpdate <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n<\/tr>\n
Clone <\/td>\n\u4e0d\u652f\u6301 <\/td>\n\u4e0d\u652f\u6301 <\/td>\n\u4e0d\u652f\u6301<\/td>\n\u4e0d\u652f\u6301<\/td>\n<\/tr>\n
Close <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n<\/tr>\n
Delete <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n<\/tr>\n
GetRows <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n<\/tr>\n
Move <\/td>\n\u4e0d\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n<\/tr>\n
MoveFirst <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n<\/tr>\n
MoveLast    <\/td>\n\u4e0d\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n<\/tr>\n
MoveNext <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n<\/tr>\n
MovePrevious <\/td>\n\u4e0d\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n<\/tr>\n
NextRecordset <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n<\/tr>\n
Open <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n<\/tr>\n
Requery <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n<\/tr>\n
Resync <\/td>\n\u4e0d\u652f\u6301 <\/td>\n\u4e0d\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n<\/tr>\n
Supports <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n<\/tr>\n
Update <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n<\/tr>\n
UpdateBatch <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n\u652f\u6301 <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n

\n--------------------------------------------------------------
\n\u5176\u4e2dNextRecordset\u65b9\u6cd5\u5e76\u4e0d\u9002\u7528\u4e8eMicrosoft Access\u6570\u636e\u5e93\u3002 <\/p>\n

LockType
\nRecordset\u5bf9\u8c61Open\u65b9\u6cd5\u7684LockType\u53c2\u6570\u8868\u793a\u8981\u91c7\u7528\u7684Lock\u7c7b\u578b\uff0c\u5982\u679c\u5ffd\u7565\u8fd9\u4e2a\u53c2\u6570\uff0c\u90a3\u4e48\u7cfb\u7edf\u4f1a\u4ee5Recordset\u5bf9\u8c61\u7684LockType\u5c5e\u6027\u4e3a\u9884\u8bbe\u503c\u3002LockType\u53c2\u6570\u5305\u542badLockReadOnly\u3001adLockPrssimistic\u3001adLockOptimistic\u53caadLockBatchOptimistic\u7b49\uff0c\u5206\u8ff0\u5982\u4e0b\uff1a <\/p>\n\n\n\n\n\n\n\n
\u5e38\u6570<\/span> <\/td>\n\u5e38\u6570\u503c<\/span> <\/td>\n\u8bf4\u660e<\/span> \n<\/td>\n<\/tr>\n
adLockReadOnly <\/span><\/td>\n1\u7f3a\u7701\u503c<\/span> <\/td>\nRecordset\u5bf9\u8c61\u4ee5\u53ea\u8bfb\u65b9\u5f0f\u542f\u52a8\uff0c\u65e0\u6cd5\u8fd0\u884cAddNew\u3001Update\u53caDelete\u7b49\u65b9\u6cd5<\/span> <\/td>\n<\/tr>\n
adLockPrssimistic <\/span><\/td>\n2<\/td>\n\u5f53\u6570\u636e\u6e90\u6b63\u5728\u66f4\u65b0\u65f6\uff0c\u7cfb\u7edf\u4f1a\u6682\u65f6\u9501\u4f4f\u5176\u4ed6\u7528\u6237\u7684\u52a8\u4f5c\uff0c\u4ee5\u4fdd\u6301\u6570\u636e\u4e00\u81f4\u6027<\/span> <\/td>\n<\/tr>\n
adLockOptimistic <\/span><\/td>\n3<\/td>\n\u5f53\u6570\u636e\u6e90\u6b63\u5728\u66f4\u65b0\u65f6\uff0c\u7cfb\u7edf\u5e76\u4e0d\u4f1a\u9501\u4f4f\u5176\u4ed6\u7528\u6237\u7684\u52a8\u4f5c\uff0c\u5176\u4ed6\u7528\u6237\u53ef\u4ee5\u5bf9\u6570\u636e\u8fdb\u884c\u589e\u3001\u5220\u3001\u6539\u7684\u64cd\u4f5c<\/span> <\/td>\n<\/tr>\n
adLockBatchOptimistic <\/span><\/td>\n4<\/td>\n\u5f53\u6570\u636e\u6e90\u6b63\u5728\u66f4\u65b0\u65f6\uff0c\u5176\u4ed6\u7528\u6237\u5fc5\u987b\u5c06CursorLocation\u5c5e\u6027\u6539\u4e3aadUdeClientBatch\u624d\u80fd\u5bf9\u6570\u636e\u8fdb\u884c\u589e\u3001\u5220\u3001\u6539\u7684\u64cd\u4f5c<\/span> <\/td>\n<\/tr>\n<\/tbody>\n<\/table>\n","protected":false},"excerpt":{"rendered":"

recordset.Open Source,ActiveConnection,CursorType,LockType,Options <\/p>\n

\u53ef\u4ee5\u5199\u6210\uff1a
\nrs.open SQL\u8bed\u53e5,conn\u5bf9\u8c61,3\uff08\u6e38\u6807\u7c7b\u578b\uff09,2\uff08\u9501\u5b9a\u65b9\u6cd5\uff09 <\/p>\n

Source<\/strong>
\nRecordset\u5bf9\u8c61\u53ef\u4ee5\u901a\u8fc7Source\u5c5e\u6027\u6765\u8fde\u63a5Command\u5bf9\u8c61\u3002Source\u53c2\u6570\u53ef\u4ee5\u662f\u4e00\u4e2aCommand\u5bf9\u8c61\u540d\u79f0\u3001\u4e00\u6bb5SQL\u547d\u4ee4\u3001\u4e00\u4e2a\u6307\u5b9a\u7684\u6570\u636e\u8868\u540d\u79f0\u6216\u662f\u4e00\u4e2aStored Procedure\u3002\u5047\u5982\u7701\u7565\u8fd9\u4e2a\u53c2\u6570\uff0c\u7cfb\u7edf\u5219\u91c7\u7528Recordset\u5bf9\u8c61\u7684Source\u5c5e\u6027\u3002 <\/p>\n

ActiveConnection<\/strong>
\nRecordset\u5bf9\u8c61\u53ef\u4ee5\u901a\u8fc7ActiveCon...<\/span> \u7ee7\u7eed\u9605\u8bfb →<\/span><\/a><\/p>\n","protected":false},"author":1,"featured_media":0,"comment_status":"open","ping_status":"open","sticky":false,"template":"","format":"standard","meta":{"footnotes":""},"categories":[273],"tags":[81],"class_list":["post-248","post","type-post","status-publish","format-standard","hentry","category-article","tag-ado"],"_links":{"self":[{"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/posts\/248","targetHints":{"allow":["GET"]}}],"collection":[{"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/posts"}],"about":[{"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/types\/post"}],"author":[{"embeddable":true,"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/users\/1"}],"replies":[{"embeddable":true,"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/comments?post=248"}],"version-history":[{"count":0,"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/posts\/248\/revisions"}],"wp:attachment":[{"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/media?parent=248"}],"wp:term":[{"taxonomy":"category","embeddable":true,"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/categories?post=248"},{"taxonomy":"post_tag","embeddable":true,"href":"https:\/\/www.xiaobo.li\/notes\/wp-json\/wp\/v2\/tags?post=248"}],"curies":[{"name":"wp","href":"https:\/\/api.w.org\/{rel}","templated":true}]}}