Dim Conn As ADODB.Connection
Dim Connres As ADODB.Recordset
Set Conn = New ADODB.Connection
Set Connres = New ADODB.Recordset
Conn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=zhongyuan;Data Source=" & Trim(Server)
Conn.ConnectionTimeout = 10
Conn.Open
Connres.Open "select DISTINCT nr from mxb", Conn, adOpenStatic, adLockPessimistic
If Connres.RecordCount = 0 Then Exit Sub
Connres.Open "select DISTINCT nr from mxb", Conn, adOpenStatic, adLockPessimistic就是这句我使用DISTINCT消除重复键会使的Connres.RecordCount=-1,而如果不加DISTINCT则没有问题,求解
Dim Connres As ADODB.Recordset
Set Conn = New ADODB.Connection
Set Connres = New ADODB.Recordset
Conn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=zhongyuan;Data Source=" & Trim(Server)
Conn.ConnectionTimeout = 10
Conn.Open
Connres.Open "select DISTINCT nr from mxb", Conn, adOpenStatic, adLockPessimistic
If Connres.RecordCount = 0 Then Exit Sub
Connres.Open "select DISTINCT nr from mxb", Conn, adOpenStatic, adLockPessimistic就是这句我使用DISTINCT消除重复键会使的Connres.RecordCount=-1,而如果不加DISTINCT则没有问题,求解
解决方案 »
- 软件选择功能安装
- 求助,treeview 滚动条的位置?
- sndPlaySound32在播放声音时的问题,请高手指点
- 还是哪个该死的Winsock的程序调试不过,在这里麻烦大家了
- 本公司现在需要招聘一个vb+数据库+报表的开发人员
- 送分!请问各位朋友:有谁知道“ActiveThreed Plus 3.01”和“ActiveListBar 1.0”哪里有这两个控件的下载?
- Richtextbox的转换,急!:-(
- 哪位仁兄知道怎样把数组中的数据转换成picturebox中的像素点?
- yangzhaoyu(老妖)领分
- 在局域网内,我想访问另一台电脑(win98对等网)上的数据库,最好最简明的方法是什么?
- 请指教啊!水晶报表的问题!!
- VB中Excel小計問題
=================
学习技巧与源码下载站:
http://www.j2soft.cn/
http://j2soft.008.net/
Dim Conn As ADODB.Connection
Dim Connres As ADODB.Recordset
Set Conn = New ADODB.Connection
Set Connres = New ADODB.Recordset
Conn.ConnectionString = "Provider=SQLOLEDB.1;Persist Security Info=False;User ID=sa;Initial Catalog=zhongyuan;Data Source=" & Trim(Server)
Conn.ConnectionTimeout = 10
cOnn.CursorLocation = adUseClient'设为客户端游标
Conn.Open
Connres.Open "select DISTINCT nr from mxb", Conn, adOpenStatic, adLockPessimistic
If Connres.RecordCount = 0 Then Exit Sub