5853.html
来自「VB技巧问答10000例,是一个教程」· HTML 代码 · 共 38 行
HTML
38 行
<html>
<head>
<title>扂妏蚚RDO源杨溼恀挂侬ACESS97杅擂踱夔伧髡ㄛ笋岆参杅擂踱COPY善NT SERVER4﹝0腔Cㄩ\winnt,肮欴扢离32弇ODBCㄛ□軞岆蟀诿祥善杅擂埭ㄛ□恀跪弇湮狨妦系埻秪ˋ</title>
</head>
<body bgcolor="#FFFFFF" vlink="#808080">
<center>
<h1>扂妏蚚RDO源杨溼恀挂侬ACESS97杅擂踱夔伧髡ㄛ笋岆参杅擂踱COPY善NT SERVER4﹝0腔Cㄩ\winnt,肮欴扢离32弇ODBCㄛ□軞岆蟀诿祥善杅擂埭ㄛ□恀跪弇湮狨妦系埻秪ˋ</h1>
</center>
<hr size=7 width=75%>
<hr size=7 width=75%><p>
Posted by <a href="mailto:ylj@zhuhaiinfo.net">wen</a> on September 21, 1998 at 16:01:31:<p>
扂妏蚚RDO源杨溼恀挂侬ACESS97杅擂踱夔伧髡<br>program as follows:<br>Private Sub Form_Load()<br>Dim db As rdoConnection<br>Dim rs As rdoResultset<br>Dim ssql As String<br>Set db = rdoEngine.rdoEnvironments(0).OpenConnection("yuan1")<br>ssql = "select * from branch"<br>Set rs = db.OpenResultset(ssql, rdOpenKeyset, rdConcurRowVer)<br>rs.MoveFirst<br>rs.Delete<br>While Not rs.EOF<br> rs.MoveNext<br> Wend<br> rs.Close<br> db.Close<br>End Sub<br>婓NT SERVER4.0腔control panel: 扂辆俴肮欴腔杅擂埭扢离ㄛ□衄渣昫<br>program as follows:<br> Option Explicit<p>Public en As rdoEnvironment<br>Public cn As rdoConnection<br>Private Sub Form_Load()<br>Dim scnct As String<br>Dim rs As rdoResultset<br>Dim ssql As String<p>Set en = rdoEngine.rdoEnvironments(0)<br>scnct = "c:\winnt\db1.mdb;Driver=C:\WINNT\System32\odbcjt32.dll;" _<br>& "DriverID=25;FIL=MS Access;UID=;PWD=;"<br>Set cn = en.OpenConnection(dsname:="yuan", prompt:=rdDriverNoPrompt, ReadOnly:=False, Connect:=scnct)<br>ssql = "select * from branch"<br>Set rs = cn.OpenResultset(ssql, rdOpenKeyset, rdConcurRowVer)<br>rs.delete<br>While Not cn.EOF<br>rs.MoveNext<br>Wend<br>rs.Close<br>cn.Close<br>End Sub<p>
<br>
<br><hr size=7 width=75%><p>
<a name="followups">Follow Ups:</a><br>
<ul><!--insert: 5853-->
<!--top: 5876--><li><a href="5876.html">Connect String incorrect</a> <b>小吴</b> <i>08:23:40 9/22/98</i>
(<!--responses: 5876-->3)
<ul><!--insert: 5876-->
<!--top: 5879--><li><a href="5879.html">Re: Connect String incorrect(there is also the same error.</a> <b>wen</b> <i>08:45:26 9/22/98</i>
(<!--responses: 5879-->2)
<ul><!--insert: 5879-->
<!--top: 5912--><li><a href="5912.html">Sorry, this works!</a> <b>小吴</b> <i>08:01:28 9/23/98</i>
(<!--responses: 5912-->1)
<ul><!--insert: 5912-->
<!--top: 5913--><li><a href="5913.html">Re: Sorry, this works!(there is the same error)</a> <b>wen</b> <i>08:39:32 9/23/98</i>
(<!--responses: 5913-->0)
<ul><!--insert: 5913-->
</ul><!--end: 5913-->
</ul><!--end: 5912-->
</ul><!--end: 5879-->
</ul><!--end: 5876-->
</ul><!--end: 5853-->
<br><hr size=7 width=75%><p>
</body></html>
⌨️ 快捷键说明
复制代码Ctrl + C
搜索代码Ctrl + F
全屏模式F11
增大字号Ctrl + =
减小字号Ctrl + -
显示快捷键?