|
<p><font face="宋体" size="2">我用VB写了一段读取SQL的用户归档的数据库表格值<br/>但是读取不上来,到了Set oRs = oCom.Execute就不继续执行了<br/>Dim sPro <br/>Dim sDsn <br/>Dim sSer <br/>Dim sCon <br/>Dim sSql <br/>Dim oRs <br/>Dim conn <br/>Dim oCom <br/>Dim oItem <br/>Dim m, n, s<br/>Dim hourdate <br/>Dim secdate <br/>Dim k<br/>Dim oList<br/>//定义变量,VBS使用变体类型,无需指定数据类型,否则编译出错<br/>Set oList = ScreenItems(&quot;listview1&quot;)//使用Listview控件<br/>oList.View =3<br/>oList.ListItems.Clear<br/>//定义控件属性<br/>sPro = &quot;Provider=WinCCOLEDBProvider.1;&quot;//定义服务提供者<br/>sDsn = &quot;Catalog=CC_test_06_03_29_12_38_33R;&quot;<br/>sSer = &quot;Data Source=.\WinCC&quot;<br/>sCon = sPro + sDsn + sSer<br/>//定义连接字符串<br/>sSql = &quot;SELECT * FROM UA#TEST&quot;//????????????<br/>//访问压缩归档的SQL语句,非压缩归档使用SELECT语句,用法见SQL<br/>MsgBox &quot;Open with:&quot; & vbCr & sCon & vbCr & sSql & vbCr<br/>//出提示框,也可以不用<br/>Set conn = CreateObject(&quot;ADODB.Connection&quot;)<br/>conn.ConnectionString = sCon<br/>conn.CursorLocation = 3<br/>conn.Open<br/>Set oRs = CreateObject(&quot;ADODB.Recordset&quot;)<br/>Set oCom = CreateObject(&quot;ADODB.Command&quot;)<br/>oCom.CommandType = 1<br/>Set oCom.ActiveConnection = conn<br/>oCom.CommandText = sSql<br/>Set oRs = oCom.Execute<br/>这是我的程序<br/>sSql = &quot;SELECT * FROM UA#TEST&quot; ,TEST是我的用户归档名称<br/>是不是这里出现了问题<br/>请哪个高手 能帮我指出问题~ 谢谢了</font><br/></p> |
|